SELECT with inheritance in model

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
peledkfir
Posts: 22
Joined: Sat 15 Jan 2011 11:06

SELECT with inheritance in model

Post by 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

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by 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.

Post Reply