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.
Last Modified: 26-OCT-00