Subject Re: [Firebird-Architect] Composite index optimizer fails
Author Daniel Rail
Hello Skopalik,

Monday, May 12, 2003, 3:59:33 AM, you wrote:

> I found two situation, where optimizer use bad plan or when FB lost speed.
> I not need help, I only report tips for improvement FB server.

> First (SQL example sql1):
> AB indexd is needed for Max/Min functions in real database.
> FB select index AB, but if I plan manualy index AA, avarege speed was incresed.

> Second (SQL examlpe sql2):
> Slow evaluating of IN (BETWEEN, OR, ...) clausule.
> When I roll up into UNIONS speed was radicaly incresed.

Which version of Firebird are you using? And, on which platform?

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (