Ottó Havasvölgyi wrote:
Hi all,
Is PostgreSQL able to throw unnecessary joins? For example I have two tables, and I join then with their primary keys, say type of bigint . In this case if I don't reference to one of the tables anywhere except the join condition, then the join can be eliminated. Or if I do a "table1 left join table2 (table1.referer=table2.id)" (N : 1 relationship), and I don't reference table2 anywhere else, then it is unnecessary.

It cannot possibly remove "unnecessary joins", simply because the join influences whether a tuple in the referenced table gets selected and how many times.

Alex


--
*********************************************************************
http://www.barettadeit.com/
Baretta DE&IT
A division of Baretta SRL

tel. +39 02 370 111 55
fax. +39 02 370 111 54

Our technology:

The Application System/Xcaml (AS/Xcaml)
<http://www.asxcaml.org/>

The FreerP Project
<http://www.freerp.org/>

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to