Database Administrator Guide > Database Administrator Guide > Maintaining Storage Structures
Was this helpful?
Maintaining Storage Structures
 
Storage Structures and Performance
Table Pages
Modify Procedures
Overflow Management
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: 08/14/2024