| Subject | Re: [firebird-support] FB 2.0 / FB1.5 optimizer difference |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-12-02T09:01:08Z |
Hans wrote:
Dmitry
> Found one difference between F2.0 optimizer and FB1.5Read the release notes.
>
> select tt.* from ticketitems tt where tt.ticket_uniquenum
> not in (select t.ticket_uniquenum from tickets t )
> PLAN (T NATURAL)
> PLAN (TT NATURAL)
Dmitry