>>Just want to share this link
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/ that contains performance results for
>>IN/EXISTS/INNER JOIN and NOT IN/NOT EXISTS/LEFT JOIN by Gail Shaw.
>
>Thanks but I don't remember I asked for a link. Why would you share it especially when nothing in it that contradicts what I have said.
>Cetin
Simply because you're not the only reader of this thread and the link with performance results may be helpful for other people as well. This thread was just useful to put it here.
If it's not broken, fix it until it is.
My Blog