HP NonStop G-Series User Manual

Page 71

Advertising
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.

Advertising