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

            Issue Links

              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: