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

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.