Re: Eliminating unnecessary left joins

Sorry, I have left out the PK requirement.
What Nicolas wrote is right, I also use an O/R mapper and inheritance is
solved with vertical partitioning. The tables are connected to each other
with the PK. And the mapper defines views for each class with left joins.
The mapper generates queries based on these views. A high fraction of
the joins would be eliminated almost in every query.

My simple example:

Class hierarchy and fields:
Shape (ID, X, Y)
|
+-Circle (ID, Radius)
|
+-Rectangle (ID, Width, Height)

The mapper creates 3 tables with the columns next to the class name.
And it creates 3 views. One of them:

RectangleView: SELECT r."ID" as "ID", s."X" as "X", s."Y" as "Y", r."Width"
as "Width", r."Height" as "Height" FROM "Rectangle" r LEFT JOIN "Shape" s ON
( r.ID=s.ID)

Now if I query Rectangle object IDs, whose Width is greater than 5, it will
generate this:

SELECT "ID" FROM RectangleView WHERE "Width">5

In this case I don't need to left join the Shape table, because X and Y
columns are not used.

The other typical situation is when I execute more complex,
not-O/Rmapper-generated SQL commands based on these views for reporting. For
example the average width of rectangles whose height is greater than 10.
----------------------------------------------------

This optimization should be also applied to subqueries.

Is this optimization relatively easy to introduce?

I would gladly work on this, but unfortunately I don't know the codebase at
all.
I would really appreciate if someone competent implemented this feature in
8.4.

Thank you in advance,
Otto