Updating Table statistics for a table on the DB2 Server for VSE & VM

Open the Update Table Statistics window to update table statistics for all columns or for a column which is the first column of any index. 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.

Fields and controls

Authorities and privileges



To update table statistics:

  1. Open the Update Table Statistics window.
  2. Specify the level of statistics you want to update for the table by selecting radio button Update statistics for all columns or Update statistics for a column which is the first column of any index.
  3. Click on OK to begin collecting the statistics.


Related information