17. Improving Database and Query Performance : Database Maintenance Issues
 
Share this page                  
Database Maintenance Issues
If your query used to run quickly and is now slower, or the speed of the query changes depending on the constants specified in the WHERE clause, your problem can be poor database maintenance.
To optimize performance, set up maintenance procedures that run DBA utilities.
The following features are especially useful in tracking performance problems:
Optimization
Modification of table and index structure
System modification
Verification
For discussions of maintenance issues, see the chapters “Maintaining Databases,” “Maintaining Storage Structures,” and “Using the Query Optimizer.”