Teradata Vantage Certified Associate — Question 32

Which index type is most efficient for range-based queries?

Answer options

• A. Unique primary index (UPI)
• B. Partitioned primary index (PPI)
• C. Non-unique primary index (NUPI)
• D. Unique secondary index (USI)

Correct answer: B

Explanation

The Partitioned primary index (PPI) is designed to handle range-based queries efficiently by organizing data into segments, allowing for faster access. In contrast, the Unique primary index (UPI) and Unique secondary index (USI) are optimized for single-value lookups, while the Non-unique primary index (NUPI) does not provide the same level of efficiency for range queries as PPI.