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, click the push button to show a list of existing indexes and owners.
   
   
2. In the Select partition group of radio buttons, 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.