Create new statistics
To create new statistics:
- In the System i Navigator window, expand a system.
- Expand Databases.
- Expand the database that contains the schema in which the table or alias is stored.
- Right-click on the table or alias and select Statistics Data.
- On the Statistics Data dialog, click New.
- On the New Statistics dialog, in the Columns available list, select the column or columns for
which you want to collect statistics.
- Click Add.
After the columns have been added to the Columns requested for collection list, you can: