Reset usage counts

Resetting the usage counts for a table allows you to determine how the changes that you have made to your indexing strategy are affecting the indexes and constraints that are created on that table. For example, if your new strategy causes an index to never be used, you may then be able to delete that index. Resetting usage counts on a table affect all indexes and constraints that are created on that object.

Note: Resetting usage counts for a keyed physical file or a constraint in the Show Indexes window resets the counts of affects all constraints and keyed access for that file or table.

You can also reset usage counts for specific indexes.

To reset usage counts for a table:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Table container object.
  5. Right-click a table and select Reset usage counts.