Create Index
Purpose
The Create Index statement creates an index on one or more columns in a local table.
Syntax
CREATE [UNIQUE] INDEX index_name ON table_name (column_name [, ...])
where:
UNIQUE
means that key columns cannot have duplicate values.
index_name
specifies the name of the index to be created.
table_name
specifies an existing local table.
column_name
specifies an existing column.
Notes
![*](bullet.png)
The driver cannot create an index in a remote table; the driver returns an error indicating that the operation cannot be performed on a remote table.
![*](bullet.png)
Creating a unique constraint is the preferred way to specify that the values of a column must be unique.