Use the Run Statistics window to update system catalog statistics on the
data in a table, the data in the table's indexes, or the data in both the
table and its indexes. The optimizer uses these statistics to choose
which path will be used to access the data.
In general, you want to update statistics if there have been extensive
changes to the data in the table.
Before you begin...
To update statistics:
- Open the Run Statistics window.
- Specify the level of statistics you want to gather for the table by
selecting a radio button under Statistics for the
table.
- Specify the level of statistics you want to gather for the table's
indexes by selecting a radio button under Statistics
for the indexes.
- Use the Share level radio buttons to
specify the type of access you want other users to have to the table while the
statistics are being gathered.
- Click on OK to begin collecting the statistics.
Related information
- RUN STATISTICS command --
See
the Command Reference
- RUNSTATS utility--
See
the Administration Guide
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]