Create new statistics

To create new statistics:

  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. Right-click on the table or alias and select Statistics Data.
  5. On the Statistics Data dialog, click New.
  6. On the New Statistics dialog, in the Columns available list, select the column or columns for which you want to collect statistics.
  7. Click Add.

After the columns have been added to the Columns requested for collection list, you can: