CREATE INDEX, Join and Hash Indexes | Teradata Vantage - 17.10 - CREATE INDEX, Join Indexes, and Hash Indexes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
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.