[All]
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.
Connect with Us