执行查询
explain select colD from test where colA='' and colB='' and colC='' and colD>=xxx and colD<=xxx
为何这个查询命中了indexA的索引?
...全文
532打赏收藏
组合索引问题请教
大家好 某一表中有如下索引 UNIQUE indexA(`colE`,`colA`,`colD`,`colB`,`colC`) indexB(`colA`,`colB`,`colC`,`colD`) 执行查询 explain select colD from test where colA='' and colB='' and colC='' and colD>=xxx and colD<=xxx 为何这个查询命中了indexA的索引?