V2EX › Aplusplus 的所有回复 › 第 1 页 / 共 1 页

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

2022 年 11 月 3 日

回复了 JinTianYi456 创建的主题 › MySQL › SQL 中 on 条件与 where 条件的区别

@L0L Do you have an example? I don't think CBO is involve because it's the same cost between inner join conjuncts and join output filter.

2022 年 11 月 3 日

回复了 JinTianYi456 创建的主题 › MySQL › SQL 中 on 条件与 where 条件的区别

No difference. Optimizers can move both to inner join conjuncts or filter project after inner join. Regardless, the underlying expression evaluation is the same.