Improved reordering of local filter expressions
Details
| Detail name | Value |
|---|---|
| Changelog Number | 2765 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.0 |
| Resolution Date | 2021-08-03 |
Background
The WHERE clause of a join query typically contains join expressions and filter expressions. Local filter expressions refer to a single table and are evaluated as part of the SCAN or JOIN of that table.
Query performance can vary depending on the order of these local filter expressions.
Improvement
The reordering of local filter expressions has been improved to evaluate cheaper expressions first if possible.
