Thank you very much for your answer, Dmitry :)

I converted the few IF NOT IN instances
to IF NOT EXISTS and it all seems to be
up to speed again

----- Original Message -----
From: "Dmitry Yemanov" <dimitr@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, December 02, 2006 7:56 PM
Subject: Re: [firebird-support] FB 2.0 / FB1.5 optimizer difference


> Hans wrote:
>> All I have been able to find on page 62 is
>>
>> 'More Optimization of NOT Conditions'
>> 'NOT conditions are simplified and optimized via an index when possible'
>
> Sorry, this is my fault. It's on page 102, but only the ALL predicate is
> mentioned there. The fact that NOT IN is equal to <> ALL is implied, but
> it's not very obvious for everybody.
>
> v2.0 de-optimizes both ALL and NOT IN subqueries in order to guarantee a
> consistent result.
>
>
> Dmitry
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>