User guide

Analyzing and Tuning Query Performance7-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
atable
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.