CREATE TABLE (Time Series Form) | Teradata Vantage - 17.10 - CREATE TABLE (Time Series Form) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1208-171K
Language
English (United States)

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.