|Subject||Re: [firebird-support] FB 2.0 / FB1.5 optimizer difference|
> Hans wrote:Thank you for the warning. Sometimes I wished that there was
>> 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.
a setting available per database or per table that elimated all
NULLs and replaced them by 0 :)