Subject | Re: Compound Index |
---|---|
Author | pokka_chi |
Post date | 2007-05-03T08:50:35Z |
--- In firebird-support@yahoogroups.com, Arno Brinkman <fbsupport@...>
wrote:
PK
wrote:
>query :
> As Ivan already suggested what is the nr. of reads if you use this
>COLUMN1, COLUMN2
> SELECT FIRST 10 * FROM MY_TABLE WHERE COLUMN1 >= 101 ORDER BY
>I've tried this. The number of reads is 90320. The time is 23 seconds.
PK