Multiple choice technology databases

Secondary 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
A Correct answer
Explanation

Secondary Index in Teradata is primarily used to optimize data access - it provides an alternate path to locate rows without full table scans. Secondary Indexes do NOT determine data distribution across AMPs; only the Primary Index controls distribution. Option A correctly identifies the access purpose.

Keep practicing — related questions