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