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

Teradata Database Design

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

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.