Value-Ordered NUSIs and Range Conditions - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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).