SELECT with inheritance in model

[peledkfir]

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

[Shalex]

It is difficult to guess from your post which exact case we should optimize. Please send us a small test project with the corresponding DDL script to reproduce the issue in our environment.