15.00 - Value-Ordered NUSIs and Range Conditions - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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