Subject Re: [firebird-support] FB 2.0 / FB1.5 optimizer difference
Author Hans
> 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 :)