Hi,

>> 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.

And the returned PLAN is "PLAN (MY_TABLE ORDER MY_INDEX INDEX (MY_INDEX))"?
If yes, i miss something here.
Column1 and Column2 are integer fields?
Do you've an ODS 11 database (created in FB2)?
Can you prepare a simple database where this is reproducable (only the table you meantion)?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info