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