>>>>It depends, but in most cases I tried LEFT JOIN was the fastest method.
>>>
>>>What is that most case and how it depends? In all cases I tried it was the slowest.
>>>Cetin
>>
>>I think it depends on number of records in each table.
>
>You think:) Ok I understand that. My tests were with large tables,
>PS: If you check excution plan of 'in', exists and left join, the latter adds an extra step to other plans.
>Cetin
Ok, I'll compare the execution plans.
If it's not broken, fix it until it is.
My Blog