In my model I have some entities mapped by table per subclass.
The sql generates when selecting the Set is some kind of
select * from tbl1
union all
(select * from tbl2
union all
(select * from tbl 3....
And so on.. it is a performance killer
My question is if you can consider to improve it to
select * from tbl1
union all
select * from tbl2
union all
select * from tbl3 .. and so on..
My current workaround is to select from the set using OfType but it brakes the code generic
I'm using dot connect 6.10.141 with oracle 11.2g