TDVCL1 Exam QuestionsBrowse all questions from this exam

TDVCL1 Exam - Question 35


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

Show Answer
Correct Answer: B

A partitioned primary index (PPI) is most efficient for range-based queries. PPIs distribute data across partitions based on the range of values, which makes it easier and faster to query a specific range. In contrast, unique primary indexes (UPI), non-unique primary indexes (NUPI), and unique secondary indexes (USI) are not specifically optimized for range-based queries, making them less efficient for this purpose.

Discussion

1 comment
Sign in to comment
lmtome44Option: D
Dec 3, 2023

The most efficient index type for range-based queries is a unique secondary index (USI). A USI is a secondary index that is created on a column that can contain duplicate values. This means that the USI can be used to quickly find all of the records that have a value in a given range.