Do I Still Need to Backup and Restore to Balance my Indexes?

By: Borland Staff

Abstract: Backup and Restore is still recommended

Problem:
I heard that 5.0 maintains indexes automatically.   Is it still necessary to 
deactivate and reactivate the indexes or backup and restore 
the database to rebalance indexes?

Solution:
/*******************************************************************************/
Note: The information in this article applies to
            InterBase versions 3.3 and up.
/********************************************************************************/

The database does do garbage collection on indexes. This
prevents major imbalances from ocurring in indexes. However,
it is recommended that users still backup and restore their
databases anyway.

Server Response from: ETNASC04