 |
AplusplusV2EX member #43064, joined on 2013-08-02 18:35:16 +08:00 |
 |
Per Aplusplus's settings, the topics list is hidden |
Deals info, including closed deals, is not hidden
Aplusplus's recent replies
Nov 3, 2022 Replied to a topic by 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.
Nov 3, 2022 Replied to a topic by 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