DB2 Help

Select one of the following radio buttons to specify whether and how you want the table's indexes' statistics updated:

Do not update: Statistics for the table's indexes are not updated. Select this radio button if you want to update statistics for only the table.
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 that are needed to read the data pages into buffer pools of various sizes.