15.00 - Defining Join Indexes with Inequality Conditions - Teradata Database

Teradata Database Design

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

Defining Join Indexes with Inequality Conditions

You can define join indexes using inequality conditions.

To define inequality conditions between 2 columns of the same type, either from the same table or from two different tables, you must AND them with the other join conditions.

This enables the Optimizer to resole a request using a join index more frequently than would otherwise be possible, avoiding the need to access base data tables to retrieve the required data.