Altering an index

Authorities and privileges


To alter an index:

1. Open the Alter Index window.
   
   
2. The information on the Index page is read-only, except for the index type radio buttons. The Index page describes the index that is currently being altered. You cannot alter the index name, index owner, or other properties listed on this page.
   
   You can use the Index type radio buttons to convert the index from a type 1 to a type 2. Use type 2 indexes whenever possible. Type 2 indexes provide functions that are unavailable with type 1 indexes, such as:
   • Row locking on the table space
   • UR isolation for an access path
   • Processing of queries by multiple parallel tasks
   • Concurrent access to separate logical partitions
   
   
   
3. Specify new values for the optional properties in the Properties page.
   
   
4. If you are altering a non-partitioned index, specify new values for storage allocation properties in the Index Space Management page.
   
   
5. If you are altering a partitioned index, change partition management properties in the Partition Management page. The Data management at partition level displays the defined partition management settings. To change the properties of a partition, click the Change push button.
   
   
6. Click OK to alter the index.
   
   

• Creating an index
• Stopping indexes
• Starting indexes