Which index type is most efficient for range-based queries?
Which index type is most efficient for range-based queries?
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.
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.