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:

For discussions of maintenance issues, see the chapters “Maintaining Databases,” “Maintaining Storage Structures,” and “Using the Query Optimizer.”