Multiple choice technology databases

It is impossible to have skewed data when employing a Non-Unique Primary Index value?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

NUPI can cause data skew because all rows with the same index value hash to the same AMP. If many rows share one NUPI value, that AMP becomes overloaded while others may be underutilized.