Transitive join conditions resulting in inefficient source queries in EDS
Issue
- We are having problems with the query generated by Teiid due to transitive join condition.
- the extra joins added by transitive join conditions have caused some serious performance issue.
- Is there a way to turn transitive join conditions off?
Environment
- Red Hat JBoss Enterprise Data Services (EDS) 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.