 |
AplusplusV2EX 第 43064 号会员，加入于 2013-08-02 18:35:16 +08:00 |
Aplusplus 最近回复了
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.
Select Language