Changes an index. The ALTER INDEX statement allows you to:

    o  Change the characteristics of index nodes (sorted indexes
       only)

    o  Change the names of the storage areas that contain the index

    o  Enable or disable logging to the .aij and .ruj files

    o  Alter index partitions

    o  Change a partition name

    o  Change the description of a partition

    o  Specify whether or not the index is UNIQUE

    You cannot change:

    o  The columns that comprise an index

    o  A hashed index to a sorted index

    o  A sorted index to a hashed index

    o  A sorted, nonranked index to a sorted, ranked index

    o  A sorted, ranked index to a sorted, nonranked index

    o  The duplicates compression of a sorted, ranked index