Multiple choice technology databases

Reading the rows using Non-Unique Secondary index is

  1. One or Two AMP operation

  2. All AMP operation

  3. Many AMP operation

  4. Full table scan
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Non-Unique Secondary Index (NUSI) allows duplicate values, so a single NUSI value can point to rows on multiple AMPs. When querying via NUSI, Teradata must check all AMPs that might contain matching rows, making it an All-AMP operation. Unlike USI (which typically hits 1-2 AMPs), NUSI requires broader scanning. Option B correctly identifies this as an All-AMP operation.

Keep practicing — related questions