Thanks for the info - actually, we've kicked, bought, and driven the
Firebird database in our product line and have been very happy with it
AND THE SUPPORT!!



pbt.



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Thursday, May 31, 2007 4:05 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] database indicies



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.

Cheers,

Ann





[Non-text portions of this message have been removed]