Transitive join conditions resulting in inefficient source queries in EDS

Solution Unverified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In