A major responsibility of the database administrator is to maintain good performance. Performance-enhancing tasks related to storage structures include:

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.”