CREATE INDEX

Teradata® Database SQL Data Definition Language Syntax and Examples

brand
Software
prodname
Teradata Database
vrm_release
16.20
category
Programming Reference
featnum
B035-1144-162K

Purpose

Creates a secondary index on an existing data table or join index.

Teradata® Database SQL Fundamentals, B035-1141 provides an overview of secondary indexes, while Teradata® Database Design, B035-1094 provides more detail.

Required Privileges

You must have the INDEX or DROP TABLE privilege on the table or join index.

None.

Syntax