Adjust remove_redundant_join_clauses() so that when it has a choice
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Feb 2004 21:48:04 +0000 (21:48 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Feb 2004 21:48:04 +0000 (21:48 +0000)
commit6161766daf7fe49647538aedbbfbdb98406fca3d
tree36138c41be457e1c0a42d3346d80c6d8630a4ada
parentdf79b847fe8e81ede30a4ef77a1c903d1cb211cf
Adjust remove_redundant_join_clauses() so that when it has a choice
of which redundant clause to remove, it removes the more expensive one.
In simple scenarios the clauses will be like 'var = var' and there's
no difference, but we are now capable of considering cases where there
are sub-selects in the clauses, and it makes a BIG difference.
src/backend/optimizer/util/restrictinfo.c