--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@...>
wrote:

>
> When you experience "query is slow the first time" _and_ "fast the
> next time", you should check whether "garbage collection" happened in
> the first run.
> Did you already eliminate this scenario?

How do I eliminate this scenario? How do I eliminate the first time
sluggishness?

>
> If you have a compund index on (A,B) only records satisfying
> "where A=1 and B=2" should be read.
>

I thought so. I thought the response would be instant too. It just
wasn't the case.

PK