Subject Re: [firebird-support] Re: Query plan insists on NOT USING an index
Author Dmitry Yemanov
Franz J Fortuny wrote:
>
> In our development machines (client-servers), where our server has
> version 2.0.0.12748 of Firebird, the plan DOES USE the PRIMARY KEY of
> table SUBARTIS (when we use the JOINS first and later the OUTER
> joins), however, our customer has Firebird version 2.0.1.12855, which
> is a newer version.

Is a database the same or different? I suspect one of them has out of
date statistics.

> Does anybody have contact with the developers to report such a
> nuisance?

Can you provide a reproducable test case?


Dmitry