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.



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



p_b_turner wrote:

> Have a question posed by a co-worker. He wants to know what the
> underlying indexing mechanism is for the Firebird Database Tables.
> (eg. B-Tree, Hashing, etc.).
>

Essentially Falcon uses B* trees, with prefix and suffix compression.
To learn more than you care to know, look here:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;PAGES;NAME=
<http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;PAGES;NAME=>
'ibp_expert1'

Regards,

Ann





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