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'

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


> Hans wrote:
>> Found one difference between F2.0 optimizer and FB1.5
>>
>> select tt.* from ticketitems tt where tt.ticket_uniquenum
>> not in (select t.ticket_uniquenum from tickets t )
>> PLAN (T NATURAL)
>> PLAN (TT NATURAL)
>
> Read the release notes.
>
>
> 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
>
>
>