Aage Johansen wrote:
Is it necessary to rebuild indices (by ALTER INDEX INACTIVE/ACTIVE or by backup/restore)? Doesn't FB now balance the indexes dynamically?
Ann W.Harrison answers:
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.