Correlated Subqueries are not pushed to the Data Source query in MetaMatrix
Issue
- Queries containing correlated subqueries with a count(distinct X) are not sent to data source, instead are calculated within MetaMatrix when the data is returned.
- Automated test suites containing these subqueries have performance issues.
- How can we resolve this issue?
Environment
- MetaMatrix Enterprise Server 5.5.x
- Oracle ANSI XA Connector
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.