Subject Re: [firebird-support] Re: Speed of Firebird v1.52 vs. Interbase v7.1
Author Ann W. Harrison
Aage Johansen wrote:
> Nick wrote:
> > the 2 databases are logically the same but the second (firebird) one may
> > well benifit from a backup & restore to rebuild all indexes
> Good point, but doesn't Fb now balance the indexes dynamically?

Yes, but the bucket split algorithm tends to leave partially filled
buckets when indexes are built incrementally, while the fast-load
algorithm used when an index is added after data exists produces dense