Problematic Selection of a Primary Index Column Set - Teradata Database

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 “Surrogate Keys” on page 93).