User guide

Analyzing and Tuning Query Performance7-10
Change Index Statistics
You can update the number of index levels for an index in the Index
Statistics pane.
To choose the index, click on the name of the index in the Index field.
Place the cursor in its Index Level field and edit the field.
Update Catalogs
Click on Manual Stats Update at the bottom of the Table Statistics window
to update the table, column, and index statistics stored in system catalogs.
Tune the Query
You can tune the selected query by modifying the query and generating
Explain output for the modified query. To tune the query, click on Query
Analysis in the Main window, then click on Adhoc Query. The Adhoc Query
Performance Analysis window is displayed, as shown in Figure 7-12.
Figure 7-12. Adhoc Query Performance Analysis Window.