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.