Value-ordered NUSIs are efficient for range conditions. Because the NUSI rows are sorted by data value, only a portion of the index subtable must be searched for a given range of key values.
Value-ordered NUSIs are efficient for range conditions. Because the NUSI rows are sorted by data value, only a portion of the index subtable must be searched for a given range of key values.