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.