Subject Re: [firebird-support] need your advise to optimize an easy query
Author Ann W. Harrison
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,