Subject Re: [firebird-support] Re: Query plan insists on NOT USING an index
Author Alexandre Benson Smith
Dmitry Yemanov wrote:
> He said he tried the join I suggested him and no index has been used for
> SUBARTIS. This sounds weird, hence I'm asking for a plan...
> Dmitry


Well, maybe I am wrong, but from what I read (or better, from what I
understood) he always is comparing the "IN <constant>" vs "IN
<subquery>" as he tells about plans and first/second query.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil