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

Inefficient plan using cartesian join

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 7.4.1
    • Fix Version/s: 7.4, 7.6
    • Component/s: Query Engine
    • Labels:
      None

      Description

      We're trying to write a federated query, and we can't get Teiid to create an optimal plan. It is using a cartesian join, which causes Teiid to take a few hours and run out of memory, when we should be fetching a relatively small number of rows. We have tried using the new MAKEIND hint in 5.2, but Teiid seems to ignore it in this case.

      See the SOA jura for more information.

        Attachments

          Activity

            People

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            dsteigne Deborah Steigner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: