Multiple choice technology databases

Primary Index is used for

  1. Access the rows

  2. Distribution of the rows

  3. Both a and b

  4. Only for distribution of rows to particular AMPs
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Primary Index in Teradata serves a dual purpose - it determines both how rows are distributed across AMPs AND provides the primary mechanism for accessing those rows. When you query using the Primary Index value, Teradata knows exactly which AMP contains the data. Option C correctly states that Primary Index is used for both access and distribution.

Keep practicing — related questions