15.00 - Restrictions on Primary Indexes - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Restrictions on Primary Indexes

The following restrictions apply to all primary indexes.

  • A maximum of one primary index can be defined on a table.
  • You cannot define a primary index for a global temporary trace table, a NoPI table, or a column‑partitioned table. See “CREATE GLOBAL TEMPORARY TRACE TABLE” and “CREATE TABLE” in SQL Data Definition Language Detailed Topics.

  • No more than 64 columns can be specified for a primary index definition.
  • You cannot include columns having XML, BLOB, CLOB, Period, ARRAY, VARRAY, or JSON data types in any primary index definition.
  • You cannot compress the values of primary index columns.
  • You cannot compress the values of the partitioning columns defined in row partitioning.
  • You cannot column partition the table.