>>>>In your tests performance of the LEFT JOIN seems to be much worse than others. What are tables metrics and how many records did you get as a result of a query? Also, did you discharge the results or not?
>>>
>>>Yes as I told you before it was the slowest. Metric is simple. 2 million records table created, and copied onto another (structure was as simple as it can be, an ID plus a varchar data field. With a more complex structure it is likely it would be much slower). Then a few more records are added to one of them. Index created on join field.
>>>Cetin
>>
>>Yes, it's confirmed now by this blog by Gail Shaw
>>
>>
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/>>
>>In conclusion - use NOT EXISTS for checking if records don't exist in another table.
>
>I didn't need the confirmation but thanks anyway for confirming.
>Cetin
Just want to share this great blog. I wanted some confirmation / explanation myself and got them there.
If it's not broken, fix it until it is.
My Blog