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 |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2008-11-16 : 13:25:27
|
| Hi allI want to know is there any major difference (in the point of query performance ) between above operators ? How are they defferent? which one is better or has better performance and which one we should avoid from?Thanks in advance.Regards.Nothing is quite impossible! |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-11-16 : 15:11:26
|
| [IN] is the best for performance wise, and avoid [NOT IN]hey |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-11-16 : 17:46:39
|
For huge data my experience is to avoid both of them an use where exists / where not exists instead.GreetingsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
[IN] VS [NOT IN] and Performance Issue...