Owner manual

Analyzing and Tuning Query Performance7-2
Figure 7-1. Program Query Performance Analysis Window.
Choose a Program
Use the Catalogs and Programs pane to choose the program for analysis, as
showninFigure7-2.
Figure 7-2. Catalogs and Programs
To choose a program
1. In the Catalogs field, double-click on the name of the catalog that
contains the program. All of the programs in the selected catalog are
displayed in the Programs field.
2. In the Programs field, double-click on the name of the program that
contains the query or queries. The versions of Explain output are
displayed in the Versions pane, as shown in Figure 7-3. The
compilation date and version number of each version is displayed.