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
indexes.


Regards,


Ann