>>Do you have index with the exact expression in both tables? You can also change NOT IN to NOT EXISTS
>>
>>If you don't have an index, may be you can check each field individually (with NOT EXISTS).
>
>I think it was identical, Naomi, but will try again.
>
>Alex
I always prefer NOT EXISTS to NOT IN. In addition, you don't need a complex index expression and can instead have indexes on individual fields.
If it's not broken, fix it until it is.
My Blog