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

Improved reordering of local filter expressions

    XMLWordPrintable

    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

          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: