Improve NL joins of "OR NULL" equi joins
Details
| Detail name | Value |
|---|---|
| Changelog Number | 836 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | EXASOL 6.0.0 |
| Resolution Date | 2017-03-16 |
Joins of the form
.... T1 join T2 on (T1.IDX = T2.IDX) or (T1.IDX is NULL and T2.IDX is NULL)
are now executed more efficiently by using index joins instead of a nested loop joins.
