JBoss EDS does not push with clause pushed down to Oracle datasource
Issue
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?
Environment
- Red Hat JBoss Data Services (EDS)
- 5.2.0
- 5.3.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.