EXPLAIN select * from suoyin_test where c2=‘a1‘ and c1=‘a1‘
EXPLAIN select * from suoyin_test where c1 like ‘a1%‘ and c2=‘a1‘
EXPLAIN select * from suoyin_test where c1 like ‘a1%‘ and c3=‘a1‘
EXPLAIN select * from suoyin_test where c1=‘a1%‘ and c2=‘a1‘ ORDER BY c3
EXPLAIN select * from suoyin_test where c1=‘a1%‘ and c3=‘a1‘ ORDER BY c2
nysql索引
标签：分享图片 自己 ima 索引 log ext span win www.