Relationship Between a NUSI Subtable Row and Base Table Rows - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Relationship Between a NUSI Subtable Row and Base Table Rows

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

 

This relationship …

Reflects the fact that …

0:1

an AMP contains no NUSI subtable index rows for a particular NUSI value.

1:1

an AMPs contains 1 NUSI subtable index row for a particular NUSI value.

1:M

an AMP contains more than 1 NUSI subtable index row for a particular NUSI value.