Subject Re: [firebird-support] database indicies
Author Ann W. Harrison
Peter Turner wrote:
> I think this is exactly what we're looking for. As a side, he informed
> me that this information is important to a DB Admin when kicking the
> tires on a database engine.
OK, if he's tire kicking, he should know that Firebird does a two-stage
index lookup. The first stage goes through the index, noting record
numbers of qualifying rows. The second stage reads the qualifying rows
in storage order.