Hi all,
Is there some way by which I can tell postgresql to not to consider transitive joins while considering join pairs.
I.e. Let's say a query has two join predicates one between A & B relations and the other between B and C relations.
While constructing the DP to find the best join order, the Optimizer also consider join between A & C, which can be thought of as a transitive join.
Is their some way to turn this off or tell postgresql to not to consider these type of joins ?