15.00 - Problematic Selection of a Primary Index Column Set - Teradata Database

Teradata Database Design

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

Problematic Selection of a Primary Index Column Set

When the selection of a primary index column set is problematic, consider either of the following possible solutions.

  • Create it without a primary index.
  • You can load rows into a NoPI table while you continue to determine an appropriate primary index. Such a table is sometimes referred to as a sandbox table.

  • Use an identity column as the primary index for the table (see “Identity Columns” on page 818 and “Surrogate Keys” on page 91).