select * from a where id in (select id from b) 等价于: for select id from b for select 8 from
select * from a where id in (select id from b)
等价于:
for select id from b
for select 8 from a where a.id = b.id
当b表数据必须小于a表数据时,in优于exists
select * from a where exists (select 1 from b where b.id = a.id)
等价于:
for select * from a
for select * from b where b.id = a.id
防止exists优于in
--结束END--
本文标题: mysql查询优化
本文链接: https://www.lsjlt.com/news/6581.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-28
2024-04-26
2024-04-26
2024-04-26
2024-04-26
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0