Was this helpful?
Maintaining Storage Structures
Storage Structures and Performance
A major responsibility of the database administrator is to maintain good performance. Performance-enhancing tasks related to storage structures include:
Modifying the database tables
Compressing storage structures
Managing overflow
You should understand when and how to use the modify procedures to change storage structures for tables and secondary indexes. As part of regular system maintenance, you should use modify procedures to eliminate overflow pages and recover disk space for deleted rows.
For additional information on database performance, see the chapter “Improving Database and Query Performance.”
Last modified date: 11/09/2022