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 ?

Reply via email to