-
创建联合索引
-
两个索引都匹配
explain select * from w_sexc where available_num=0 and freeze_num=100;
3.只匹配最左边的索引
explain select * from w_sexc where available_num=0
4.匹配第二个索引
explain select * from w_sexc where freeze_num=100;
没有使用索引。
5.两个索引调换位置
explain select * from w_sexc where freeze_num=0 and available_num=100;