Adding or changing index options for RUNSTATS

These steps are part of the larger task of collecting index statistics. When you complete the steps for adding or changing index options for RUNSTATS, return to the main Table Space Statistics task.

To add or change index options for table space statistics:

  1. In the Index owner field, type the index owner name.

  2. In the Index name field, type the table name. The index must already exist in the table space.

  3. In the Select partition field, specify to run statistics on all partitions or a single partition. Type a partition number in the field if you want only specific partition information updated.

  4. Select the Collect key cardinalities check box to collect key cardinalities on the concatenation of key columns for the specified indexes.

  5. Click the Add push button to add the number of key columns to be concatenated with the number of frequent values from the specified index.

  6. Click OK to accept the values and close the window.

[Return to Partitioned Table Space Statistics task ]

[Return to Table Space Statistics task ]