mysql---联合索引是否生效

最新推荐文章于 2024-03-26 06:16:49 发布

xing2233

最新推荐文章于 2024-03-26 06:16:49 发布

阅读量1.8k

点赞数 1

分类专栏： mysql 文章标签：索引 mysql

本文链接：https://blog.csdn.net/xing_____/article/details/78826508

版权

mysql 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

create table test(
id1 int ,
id2 int,
id3 int,
id4 int,
key index_id12(id1,id2)
);

用到索引
explain select * from test where id1 < 10;
用到索引
explain select * from test where id1 < 10 and id2 > 1; 
用到索引
explain select * from test where id2 > 1 and id1 < 2; 
未用到索引
explain select * from test where id2 > 1;
未用到索引
explain select * from test order by id1 desc ;
用到索引
explain select id1 from test order by id1 desc ;
explain select id1,id2 from test order by id1 desc ;
未用到索引
explain select id1,id2,id3 from test order by id1 desc ;