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.