[
https://issues.jboss.org/browse/TEIID-1792?page=com.atlassian.jira.plugin...
]
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