EXPLAIN
EXTENDED
select s.* from student s
where s.sid in (
select sid
from sc
where sc.cid = 0 and sc.score = 100);
show WARNINGS;
查看mysql sql执行器优化后的sql
![](https://img-home.csdnimg.cn/images/20240711042549.png)
EXPLAIN
EXTENDED
select s.* from student s
where s.sid in (
select sid
from sc
where sc.cid = 0 and sc.score = 100);
show WARNINGS;