索引失效原因
一.准备工作
创建student表,id是主键
创建复合索引
create index idx_name_age on student(name,age);
查看索引
show index from student;
二.索引失效原因
1.全值匹配我最爱
explain select * from student where name = '张三' and age = 1;
创建student表,id是主键
创建复合索引
create index idx_name_age on student(name,age);
查看索引
show index from student;
1.全值匹配我最爱
explain select * from student where name = '张三' and age = 1;