Subject RE: [firebird-support] Re: New Index causes unsuspecting queries to hang
Author Dmitry Yemanov
Hi,

> Ideally, the optimizer should understand that IDX5 in this
> case is futile, something it currently obviously doesn't do.

In some cases FB 1.5 does this. I'd like to see selectivities for all
indices involved. And of course I need a confirmation that the statistics is
up-to-date.


Dmitry