mysql的join的性能_mysql 子查询与join性能比较 | 学步园

最新推荐文章于 2024-04-20 22:29:04 发布

王小约

最新推荐文章于 2024-04-20 22:29:04 发布

阅读量150

点赞数

本文链接：https://blog.csdn.net/weixin_31776191/article/details/113461691

版权

数据库查询子查询连接查询性能优化 SQL

关键词由CSDN通过智能技术生成

application_daily 11万条数据,application_info400多条数据

查询结果数据为19498

1. 子查询 (0.01s)

select sql_no_cache * from application_daily where application_info_id in (select id from application_info where Team_TeamID=3)

2. 子查询 (0.002s)

select sql_no_cache * from application_daily where application_info_id in (161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190)

3.连接查询，两条语句等价(0.001s)

select sql_no_cache * from application_daily,application_info where Team_TeamID=3 and application_daily.application_info_id=application_info.id

select sql_no_cache * from application_daily inner join application_info on (application_daily.application_info_id=application_info.id) where Team_TeamID=3

结论：坚决抛弃in