Is there a way to get the EDS Processor to switch from a Merge Join to a nested loop?
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, tools, and much more.