You can make an index the primary index for the table, rename an index, or deactivate an index.
To change the component fields of an index, such as ascending or descending order or uniqueness, you must delete and then recreate the index.
To modify the properties of an index: