Subject Re: [firebird-support] in vs exist
Author Dimitry Sibiryakov
On 19 Dec 2003 at 13:15, Helen Borrie wrote:

>FB 1.5 actually resolves an IN() predicate to an EXISTS() predicate if it
>can, and then will use an index if a useful one is available. (I thought
>this was one of Arno's 1.5 optimizations, but D. Sibiryakov thinks this
>optimization was in the Fb 1.0.x engine as well..)

Hey, hey! Do you sleep enough? You should care about your health
(including mental one) and no matter how much you are payed or
Don't distort my words, please. I said that "LIKE 'string%'" can
uses index in FB1 (as STARTING WITH does) but nothing about IN.

SY, Dimitry Sibiryakov.