Hi, Julian

I’m reading Apache Calcite source code. There are some rules for Join order 
enumeration: JoinPushThroughJoinRule, JoinCommuteRule and JoinAssociateRule.
By default, JoinAssociateRule is disabled.

Does JoinPushThroughJoinRule + JoinCommuteRule prove to be complete to generate 
all the search space for Join ordering?
And why we prefer use JoinPushThroughJoinRule instead of JoinAssociateRule?

Thanks
Ken

Reply via email to