Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2872

Improved reordering of local filter expressions

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                CaptainEXA Captain EXASOL
                Reporter:
                CaptainEXA Captain EXASOL
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: