16.20 - CREATE INDEX - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1144-162K

Purpose

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

Teradata Vantage™ SQL Fundamentals, B035-1141 provides an overview of secondary indexes, while Teradata Vantage™ - 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