Update statistics data

To update a statistics data:

  1. In the System i Navigator window, expand a system.
  2. Expand Databases.
  3. Expand the database that contains the schema in which the table or alias is stored.
  4. Click either the container for the object or the All objects container.
  5. Right-click on the table or alias and select Statistics Data.
  6. On the Statistics Data dialog, click Update.
  7. On the Update Statistics dialog, select the statistics you want to update.

After the statistics have been selected, you can: