Subject Re: [firebird-support] Re: Query plan insists on NOT USING an index
Author Dmitry Yemanov
Alexandre Benson Smith wrote:
> I think he doesn't understand that FB treats as different queries a
> fixed IN select and a IN with sub-select, he thinks the two should
> produce the same kind of plan. The query Set showed him (and from what I
> understood the query you are interested on the plan) should give very
> good performance, but I think he did not tried it.

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...