15.00 - Secondary Index Build and Access Operations Summarized - Teradata Database

Teradata Database Design

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

Secondary Index Build and Access Operations Summarized

The following table summarizes how the system processes USIs and NUSIs, based on the following simple SQL requests.

  • Supporting USI build request.
  •      CREATE UNIQUE INDEX (customer_number) 
         ON customer_table;
  • Supporting NUSI build request.
  •      CREATE INDEX NUSI_name (customer_name)
         ON customer_table;
  • Supporting USI access request.
  •      SELECT * 
         FROM customer_table 
         WHERE customer_number=12;
  • Supporting NUSI access request.
  •      SELECT * 
         FROM customer_table 
         WHERE customer_name=‘SMITH’;