Create Index

The Create Index statement creates an index on one or more columns in a local table.

NOTE: 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.

Grammar

CREATE [UNIQUE] INDEX index_name ON table_name (column_name [, ...])

where:

UNIQUE means that key columns cannot have duplicate values.

NOTE: Creating a unique constraint is the preferred way to specify that the values of a column must be unique.

index_name specifies the name of the index to be created.

table_name specifies an existing local table.

column_name specifies an existing column.