ALTER INDEX

Performs a maintenance operation on an index — or on all indexes — of a table.

Syntax

Arguments

index name | ALL

The index to alter, or ALL indexes on the table.

ON table

The table the index belongs to.

operation

The maintenance operation to perform on the index.

See also

• CREATE INDEX

• DROP INDEX