Subject Re: Compound Index
Author pokka_chi
--- In firebird-support@yahoogroups.com, Arno Brinkman <fbsupport@...>
wrote:
>
> As Ivan already suggested what is the nr. of reads if you use this
query :
>
> SELECT FIRST 10 * FROM MY_TABLE WHERE COLUMN1 >= 101 ORDER BY
COLUMN1, COLUMN2
>

I've tried this. The number of reads is 90320. The time is 23 seconds.

PK