Value-Ordered NUSIs and Range Conditions
Value-ordered NUSIs are very efficient for range conditions. Because the NUSI rows are sorted by data value, it is possible to search only a portion of the index subtable for a given range of key values.
Note that for most applications, a partitioned primary index on a join index is a better choice to handle range conditions than a value‑ordered NUSI (see “Designing for Range Queries: Guidelines for Choosing Between a PPI and a Value‑Ordered NUSI” on page 456).