Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2008-12-12 : 04:16:46
|
| Hi expertsDoes writing queries in ANSI model improves the performance of the query over traditional method of joining?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-12 : 04:20:20
|
Yes! Because non-ansi style joins will result in an error, so it will never run...It still work in SQL Server 2005 and 2008 but will be removed.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-12 : 07:40:35
|
| Just to clarify a bit, the old *= and =* Sybase outer join syntax has been deprecated for a while now, and in SQL Server 2008 will generate a syntax error. You can still do inner joins using the WHERE style syntax. Either form will likely generate the same query plan for simple queries, but the ANSI style is a lot more precise and more likely to generate an optimal plan. |
|
|
|
|
|
|
Performance of ANSI join queries