mysql order 走索引么_mysql order by 使用索引情况----官网翻译

一.可以使用索引(key1,key2)联合索引列

1.select key1,key2 from t1 order by key1,key2

2.select pk,key1,key2 from t1 order by key1,key2

3.select * from t1 where key1=XX  order by key2

4.select * from t1 where key1>xxxx order by key1

5.select * from t1 where key1=xxxx and key2>xxxx order by key2

二。不能使用索引的情况

1.select * from t1 order by key1,key2;

2.select * from t1 where key2=xxxx order by key1,key3

3.select * from t1 order by key1 desc,key2 asc

4.select * from t1 where key1=xxxxx order by key1

5.select * from t1 order by abs(key)

select * from t1 order by -key;