Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4886

Allow join grouping to optimize across left outer joins

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 9.3
    • Component/s: Query Engine
    • Labels:
      None

      Description

      In a from clause such as:

      (a.t1 inner join b.t1 ... inner join a.t2 ...) left outer join b.t2 ...

      It is possible to group the b.t1 and b.t2 together, but generally won't be found by the grouping and then ordering logic.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: