Creating an index

Use the Create Index window to create an index.

Authorities and privileges


To create an index:

  1. Open the Create Index window.

  2. Specify required properties on the Index page.

  3. Specify optional properties on the Properties page .

  4. Specify storage allocation properties on the Index Space Management page.

  5. If you are creating a partitioned index, specify partition properties on the Partition Management page. (If the target table is nonpartitioned, then this tab is not available.)

  6. Click OK to create the index.

Related information