Changing index options

Use the Change Index Options window to specify what partitions to use to collect statistics in a partitioned table space, and to specify key index cardinalities for a table by defining the number of key columns and the number of frequent values to collect.

To change index options:

  1. Click the Collect key cardinalities check box.

  2. Click the Add push button to create a new row in the options box.

    1. 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.

  3. Optional: Repeat to add additional rows.

  4. Click OK to save your changes and close the window.