15.00 - Primary Index Dimensions - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Primary Index Dimensions

Primary indexes are defined across two orthogonal dimensions:

  • Unique versus nonunique (see “Unique and Nonunique Primary Indexes” on page 264).
  • Row partitioned versus nonpartitioned (see “Row-partitioned and Nonpartitioned Primary Indexes” on page 266).
  • A partitioned primary index can be row‑partitioned on anywhere from 1 to 62 levels for:

  • Base tables that are not queue tables
  • Global temporary tables
  • Volatile tables
  • Uncompressed join indexes
  • The following types of tables and indexes cannot be partitioned:

  • Queue tables
  • Row-compressed join indexes
  • Hash indexes
  • Journal tables
  • See “Row-partitioned Primary Indexes” on page 267, “Single‑Level Partitioning” on page 362, and “Multilevel Partitioning” on page 372.

    For hash and join indexes only, the primary index can also be value‑ordered.