Subject Re: [firebird-support] in vs exist
Author Helen Borrie
At 09:47 AM 19/12/2003 +0300, Dmitry Sibiryakov wrote:
>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

:-) Sorry, Dmitry.

> Don't distort my words, please. I said that "LIKE 'string%'" can
>uses index in FB1 (as STARTING WITH does) but nothing about IN.

You did, it's quite true.