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

  • No more than one primary index can be defined on a table.
  • You can also define base data tables that do not have a primary index (see “NoPI Tables, Column‑Partitioned Tables, and Column-Partitioned Join Indexes” on page 280 and “Column‑Partitioned Tables and Join Indexes” on page 285).

    You cannot define a primary index for a global temporary trace table. See “CREATE GLOBAL TEMPORARY TRACE TABLE” in SQL Data Definition Language for details.

  • No more than 64 columns can be specified in a primary index definition.
  • Primary index columns cannot be defined on columns that have XML, BLOB, CLOB, BLOB‑based UDT, CLOB‑based UDT, XML‑based UDT, Period, ARRAY, VARRAY, VARIANT_TYPE, Geospatial, or JSON data types.
  • You cannot define a primary index for a NoPI table.
  • You cannot define a primary index for column-partitioned tables and join indexes.
  • Primary index columns cannot be defined on row‑level security constraint columns.
  • You cannot specify multivalue compression for primary index columns.