beautypg.com

HP Integrity NonStop H-Series User Manual

Page 82

background image

Analyzing and Tuning Query Performance

7-8

Figure 7-11. Partition Statistics Pane.

Update Statistics

If the statistics on any of the tables have not been updated recently, you
may perform Update Statistics on any of the tables. To update statistics on
a table

1.

Click on the cell identified by the name of the table and the Update
Statistics column. The cell will display the character “y.” You may
deselect a table by clicking on the cell again.

2.

Click on Update Statistics.

3.

Use the Update Statistics window described in Chapter 12, “Managing
Tables - Statistics.”

Display Dependencies

Before updating statistics, you can analyze the impact of the changes on
other programs and objects in the Table Statistics window.

To display all programs that depend on the table you want to
modify, click on the Dependent Programs button.

This manual is related to the following products: