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

Additional optimization of left outer joins

    XMLWordPrintable

Details

    • Quality Risk
    • Resolution: Done
    • Major
    • 10.1
    • None
    • Query Engine
    • None

    Description

      Related to TEIID-5016 and TEIID-3652, there are additional circumstances where the join planning logic can combine tables from different parts of a join tree involving left outer joins.

      The referenced forum posting has a star join against ora_ses such that moving the placement of the nested inner join allows for more grouping of the join tables.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: