Selecting a Secondary Index | Database Design | VantageCloud Lake - Selecting a Secondary Index - Teradata Vantage

When assigning columns to be a secondary index for a table, there are numerous factors to consider, the most important of all being the selectivity of the index.

While USI retrievals are efficient, the efficiency of NUSI retrievals varies greatly depending on their selectivity.

For more information about secondary indexes, see CREATE INDEX and CREATE TABLE and CREATE TABLE AS .

• Optimal Data Access
• Criteria for Selecting a Secondary Index
• Secondary Index Usage Summary
• USI Summary
• NUSI Summary