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

V2EX = way to explore

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

已注册用户请登录

2022-11-03 09:19:37 +08:00

回复了 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-03 05:04:36 +08:00

回复了 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.