USI NUSI Guarantee that each complete index value is unique. Any access using the index is a two-AMP operation. Useful for locating rows having a specific value in the index. Can be hash-ordered or value-ordered.Value-ordered NUSIs are particularly useful for enhancing the performance of range queries. Can include covering columns. Any access using the index is an all-AMP operation.