15.00 - Restrictions on Secondary Indexes - Teradata Database

Teradata Database Design

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

Restrictions on Secondary Indexes

The following restrictions apply to all secondary indexes.

  • Excluding the primary index, you can define a maximum of 32 indexes on a table.
  • These 32 indexes can be any combination of secondary, hash, and join indexes, including the system‑defined secondary indexes used to implement PRIMARY KEY and UNIQUE constraints.

    Each multicolumn NUSI that specifies an ORDER BY clause counts as two consecutive indexes in this calculation.

    You cannot define secondary indexes for a global temporary trace table. See “CREATE GLOBAL TEMPORARY TRACE TABLE” in SQL Data Definition Language Detailed Topics.

  • No more than 64 columns can be included in a secondary index definition.
  • You cannot include columns having XML, BLOB, CLOB, ARRAY, VARRAY, Period, or JSON data types in any secondary index definition. Only nonunique secondary indexes are supported on columns having a Geospatial data type.