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 Assignee: Steven Hawkins Priority: Critical Fix For: 7.4, 7.6 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.