Hi Set,

> Dmitry knows the internals of Firebird better than any person who's
> never written the code, so his answer is most certainly correct and
> complete. However, some of us that don't understand the internals are
> using various tricks to fool Firebird into choosing a different plan.

Yep, I'm mostly interested in fixing the optimizer bugs/limitations rather
than using various tricks to work around <g>


Dmitry