立即学习:https://edu.csdn.net/course/play/27328/362533?utm_source=blogtoedu
未使用索引
select * from employee where salary=8800;
select * from employee where dept='部门A';
select * from employee where salary=8800 and dept='部门A';
使用索引
select * from employee where name='柳峰';
select * from employee where name='柳峰' and salary=8800;
select * from employee where name='柳峰' and salary=8800 and dept='部门A';