16.20 - CREATE INDEX, Join Indexes, and Hash Indexes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Time Series Tables and Operations

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

You can use the CREATE INDEX statement to create secondary indexes on a PTI table. For complete information about CREATE INDEX syntax, see Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144. However, you cannot create a secondary index on the TD_TIMEBUCKET, TD_TIMECODE, or TD_SEQNO system generated time series columns.

You cannot create join indexes or hash indexes on PTI tables.