Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
ALTER INDEX statementUse the ALTER INDEX statement to change the clustering attribute of an existing index. This statement is an extension to the ANSI/ISO standard for SQL.

ALTER INDEX statement

Use the ALTER INDEX statement to change the clustering attribute of an existing index. This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

Notes:

¹ See TO NOT CLUSTER Option
² See TO CLUSTER Option


Element	Description	Restrictions	Syntax
`index`	Name of the index to be altered	Must exist	Identifier

Usage

ALTER INDEX is valid only for indexes that the CREATE INDEX statement created explicitly. ALTER INDEX cannot modify an index on a temporary table, nor an index that the database server created implicitly to support a constraint.

You cannot change the collating order of an existing index. If you use ALTER INDEX to modify an index after the SET COLLATION statement of SQL has specified a non-default collating order, the SET COLLATION statement has no effect on the index.

The ALTER INDEX statement cannot reference a forest of trees index. For information on forest of trees indexes, see HASH ON clause.