16.20 - CREATE TABLE (Time Series Form) - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)
Last Update
2019-05-02

PTI tables are optimized for storing and retrieving time series data, such as sensor data. PTI tables are very similar to standard, non-PTI database tables, except that they include a PRIMARY TIME INDEX clause, rather than a PRIMARY INDEX, PRIMARY AMP INDEX, or NO PRIMARY INDEX clause.

Except as noted, most of the CREATE TABLE options available for non-PTI tables are applicable to PTI tables. For the complete CREATE TABLE syntax, see Teradata Vantageā„¢ SQL Data Definition Language Syntax and Examples, B035-1144.