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.