ALTER INDEX changes the parameters of an index.
|name||The identifier of the index you want to alter.|
Note that when enabling indexes on tables, the first index you enable must be the table’s primary index, which was created at the same time as the table itself. Only after enabling the primary index can you enable any secondary indexes.
The privileges required to execute this statement are:
- Ownership of the index.