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

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.