在a,b,c三个字段上建立一个联合索引(a,b,c)
什么语句会走index1索引呢?
select * from table where a = '1'
select * from table where a = '1' and b = ‘2’
select * from table where a = '1' and b = ‘2’ and c='3'
在a,b,c三个字段上建立一个联合索引(a,b,c)
什么语句会走index1索引呢?
select * from table where a = '1'
select * from table where a = '1' and b = ‘2’
select * from table where a = '1' and b = ‘2’ and c='3'