Alan McDonald wrote:

>>
>> i m facing a problem with a easy thing.
>> i have a table with 10 000 000 rows
>>
>> Table Property
>> Date timestamp;

...

>>
>> all columns have an index on it.

>
> you use a lot of > AND <
> do you have desc as well as asc indexes on these fields?

And have you updated the index statistics lately? Firebird does
not do that automatically.


Good luck,

Ann