beautypg.com

HP Integrity NonStop H-Series User Manual

Page 76

background image

Analyzing and Tuning Query Performance

7-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
shown in Figure 7-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.

This manual is related to the following products: