Subject Re: [firebird-support] need help on optimization
Author Ann W. Harrison
russt4 wrote:
> Hello, I'm experiencing very slow performance on quite simple
> queries. ... It appears that firebird is
> searching over every row in the table, and isn't just using
> the information in the index to construct the result.

Yes, that's part of the price of multi-version concurrency control. The
fact that a value is in the index does not mean that it's valid for your
transaction. It may have been deleted, updated, or inserted by a
concurrent transaction. The only way to validate the data is to visit
the actual records.