Changing index options

To change index options:

1. Ensure that the Index owner and the Index name fields contain the names that you want. If you want to use a different index name or index owner, either select an existing index from the Indexes page of the Table Space Statistics notebook, or use the Add Index Options window to create a new index.

2. If you are using a partitioned table space, click a radio button to indicate whether you want to use all partitions or one partition. If one partition, select the number of the partition that you want.

3. Optional: Specify frequent value statistics:
   1. Click the Collect key cardinalities check box.
   2. Click the Add push button to create a new row in the options box.
   3. Type the Number of columns and the Number of frequent values that you want.

      The Number of columns field indicates the number of key columns to concatenate. For example, if you specify 3, you will collect values on the concatenation of the first three key columns. The default is 1.

      The Number of frequent values field indicates the number of values to collect from the specified key columns. For example, if you specify 15, you will collect 15 frequent values. The default is 10.

   4. Optional: Repeat steps 3-1 to 3-3 to add additional rows.
4. Click OK to save your changes and close the window.