In doing so the optimizer will increase its degrees of freedom when performing join enumeration during its cost-based optimization phase, since these transitive conditions may permit additional alternative join orders.

• 这样,在基于成本的优化阶段中执行连接枚举时,优化程序将具有更大的自由度,因为这些传递条件允许附加的替代连接顺序。