1、查看索引
show index from student
2、增加普通索引
#增加普通索引
create index name_index on student(sname);
3、查看执行计划
#查看执行计划
explain select * from student where sno = 9999;
1、查看索引
show index from student
2、增加普通索引
#增加普通索引
create index name_index on student(sname);
3、查看执行计划
#查看执行计划
explain select * from student where sno = 9999;