15.00 - Example NUSI Definitions - Teradata Database

Teradata Database Design

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

Example NUSI Definitions

Consider the following two NUSIs created on an employee table.

     CREATE INDEX (department_number) ON employee;
 
     CREATE INDEX (job_code) ON employee;

The examples “AND Equality Condition” on page 477 and “OR Equality Condition” on page 478 examine how these dual NUSIs on the employee table might be used by the Optimizer when they are used as ANDed and ORed conditions in a WHERE clause.