Correlated Subqueries are not pushed to the Data Source query in MetaMatrix

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content