CREATE INDEX

This statement creates an index on one or more columns of a table.

To support CREATE INDEX processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_CREATE_INDEX.

The index information is mapped to a list of schema object of type DAMOBJ_TYPE_STAT. The number of stat objects in the list is based on the number of columns in the CREATE INDEX command.

Syntax

create_index ::= CREATE [UNIQUE] INDEX index_name ON base_table_name 
(column_identifier [ASC | DESC] [,column_identifier ...]...)
index_name ::= [index_qualifier.]index_name

Example

CREATE INDEX emp_i ON emp (ename);