Statistics for the table

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

Do not update

Statistics for the table are not updated. Select this radio button if you want to update statistics for only the table's indexes.

Update without distribution statistics

Basic-level statistics on the table data are updated in the system catalog tables. An example of a basic-level statistic is the number of pages being used by the table.

Distribution statistics on values in table columns are not collected.

Update with distribution statistics

Basic-level statistics on the table data are updated in the system catalog tables, and statistics on the distribution of data values in the table columns are collected. The query optimizer uses these statistics to more accurately estimate the number of rows in a column that satisfy given equalities or ranges.

An example of a distribution statistic is the frequency with which a particular data value occurs in a column.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]