SELECT with inheritance in model

SELECT with inheritance in model

Postby peledkfir » Tue 30 Aug 2011 09:25

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
peledkfir
 
Posts: 22
Joined: Sat 15 Jan 2011 11:06

Postby Shalex » Thu 01 Sep 2011 15:40

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.
Shalex
Devart Team
 
Posts: 7369
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle