Is there a way to get the EDS Processor to switch from a Merge Join to a nested loop?

Solution Verified - Updated -

Issue

  • I have noticed in one of our use case which uses internal MV, the federated joins are always using the MERGE JOIN algorithm. This is inefficient because the MV view has to always sort itself before joining to another table. Is it possible to change the join algorithm to nested loop instead?

Environment

  • Red Hat JBoss 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