Relationship between a NUSI Subtable Row and Base Table Rows - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

A NUSI subtable row points to one or more base table rows on the same AMP. The relationship between a NUSI value and any individual AMP in a configuration is either 0:1, 1:1, or 1:M.

Relationship Meaning
0:1 An AMP contains no NUSI subtable index rows for a NUSI value.
1:1 An AMPs contains 1 NUSI subtable index row for a NUSI value.
1:M An AMP contains more than 1 NUSI subtable index row for a NUSI value.