May 6, 2011 at 3:17 am
if i have an option to use either "NOT IN", "NOT EXISTS" or "LEFT JOIN" which would be best performance wise in general.
May 6, 2011 at 3:21 am
There are a series of excellent articles on Gail's Blog about such things:
http://sqlinthewild.co.za/index.php/category/sql-server/t-sql/
BrainDonor
May 6, 2011 at 5:10 am
Yes.
There is no "in general." It really depends on the situation and you should test your situation because different ones will work better under certain circumstances.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply