[teiid-issues] [JBoss JIRA] (TEIID-1792) Inefficient plan using cartesian join

[Van Halbert (Moved) (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Van Halbert moved SOA-3514 to TEIID-1792:
-----------------------------------------

              Project: Teiid  (was: JBoss Enterprise SOA Platform)
                  Key: TEIID-1792  (was: SOA-3514)
    Affects Version/s: 7.4.1
                           (was: 5.2.0.ER3)
          Component/s: Query Engine
                           (was: EDS)
             Security:     (was: JBoss Internal)

    
> Inefficient plan using cartesian join
> -------------------------------------
>
>                 Key: TEIID-1792
>                 URL: https://issues.jboss.org/browse/TEIID-1792
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4.1
>            Reporter: Debbie Steigner
>            Priority: Critical
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira