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 • 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. • Creating a unique constraint is the preferred way to specify that the values of a column must be unique.