nysql索引

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.