Creates a secondary index on an existing data table or join index.
The index name must conform to the usual rules for a Teradata SQL identifier and be unique in the table.
For more information, see Secondary Indexes (Overview) , Secondary Indexes , and Secondary Indexes.
ANSI Compliance
CREATE INDEX is a Teradata extension to the ANSI SQL:2011 standard. The ANSI SQL standard does not define DDL for creating indexes.
The CREATE UNIQUE INDEX syntax is functionally equivalent to adding a UNIQUE NOT NULL or PRIMARY KEY NOT NULL constraint set to a column in ANSI SQL:2011 if all of the columns in the column set are NOT NULL.
A CREATE UNIQUE INDEX statement on a column set where one or more columns are nullable is similar.
Required Privileges
You must have the INDEX or DROP TABLE privilege on the table or join index.
Privileges Granted Automatically
None.