> Hans wrote:
>>
>> I converted the few IF NOT IN instances
>> to IF NOT EXISTS and it all seems to be
>> up to speed again
>
> Just beware that NOT IN handles NULLs differently from NOT EXISTS.
>
>
> Dmitry
>

Thank you for the warning. Sometimes I wished that there was
a setting available per database or per table that elimated all
NULLs and replaced them by 0 :)