2.2 ALTER INDEX

---

Description

Alters an existing index by passing attributes to change to the underlying storage system. Support for ALTER INDEX depends on the underlying storage system.

Syntax

ALTER INDEX [ owner_name. ] index_name STORAGE_ATTRIBUTES `attributes' ;

Arguments

STORAGE_ATTRIBUTES `attributes'

A quoted string that specifies index attributes to change. The SQL engine passes the attributes string to the storage system, and its effects are defined by the storage manager. Some storage systems accept a `disable' attribute that temporarily disables an index, for instance.

See the documentation for your storage system for details on support for ALTER INDEX, if any.

Examples

By default, storage systems return an error in response to an ALTER INDEX statement:

ISQL> alter index t1_ix storage_attributes 'disable';

error(-20024): Sorry, operation not implemented yet

ISQL>

Authorization

The user executing this statement must have any of the following privileges:

DBA privilege.
Ownership of the index.

SQL Compliance	Extension
Environment	Embedded SQL, interactive SQL, ODBC applications
Related Statements	CREATE INDEX, DROP INDEX