Unique Secondary Indexes - Teradata VantageCloud Lake

USIs are useful both for base table access (because USI access is, at worst, a two-AMP operation) and for enforcing data integrity by applying a uniqueness constraint on a column set. Like a unique primary index, a unique secondary index can be used to guarantee row uniqueness.

• Using Unique Secondary Indexes to Enforce Row Uniqueness
• USI Access
• Unique Secondary Indexes and Performance
• Creating a Unique Secondary Index as a Composite of a Row-Level Security Constraint Column and a NUPI Column Set
• Restrictions on Load Utilities
• USI Hashing