Select one of the following radio buttons to specify
whether and how you want the table indexes' statistics updated:
- Do not update
- Statistics for the table's indexes are not updated. This is
the default.
- Update without extended index statistics
- Basic-level statistics are collected on the indexes. An example of
a basic-level statistic is the number of index leaf pages.
- Update with extended index statistics
- Basic-level and detailed statistics are collected for the indexes.
The detailed statistics can help the optimizer better estimate the I/O cost of
an index scan.
An example of a detailed statistic is the number of I/Os needed to read the
data pages into buffer pools of various sizes.
| Note: | You cannot gather statistics during the load process if you selected
Insert or Restart for the Load mode field on
the Counts page of the Load notebook.
|
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]