15.00 - Eliminating NUPI Duplicate Row Checks - Teradata Database

Teradata Database Design

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

Eliminating NUPI Duplicate Row Checks

You can eliminate duplicate row checking entirely by defining a uniqueness constraint such as PRIMARY KEY or UNIQUE NOT NULL or a USI on the primary key (or some other alternate key that can be constrained uniquely) of the table. See “Using Unique Secondary Indexes to Enforce Row Uniqueness” on page 457 for the factors that need to be considered prior to making this design decision.