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 ?