I have the following type of query:
with x (select distinct f1, f2, f3, f4, f5 from table1) select f1 from x union select f2 from x union select f3 from x union select f4 from x union select f5 from x union
table1 is from an Oracle Source and Oracle supports the with clause.
The issue I have is that EDS is not pushing the whole query down to Oracle. Instead, EDS is pushing down the
select distinct f1, f2, f3 ... f15 from table1
and then performing the unioning in EDS.
When performed on Oracle, a recordset of over 10k records and 15 union queries, as above, the query returns 7k records in under 1 second. When performed via EDS the query is taking over 5 seconds.
Is there anyway to get EDS to push down the entire query?
- Red Hat JBoss Data Services (EDS)
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.