After many changes to table data, the table and its indexes can become fragmented. Logically sequential data might reside on nonsequential pages, forcing the database manager to perform additional read operations to access data. Enterprise database servers provide utilities for maintaining the databases. For example, DB2
® provides REORG and RUNSTATS utilities to help maintain optimal performance for the database. These utilities can be configured to run automatically. Microsoft
™ SQL Server provides similar index reorganization utilities. Whether run manually or automatically, a regularly scheduled maintenance plan is essential to maintain peak performance of your system. Consult the database server product documentation for more information on database maintenance.
Parent topic: Maintaining the Lotus Notes Traveler database