mysql 避免排序_如何在mysql order by 已经加了索引的时候 排序，避免全表扫描

用到索引了的呀.

MariaDB [test]> show create table student1;

+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table |

+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| student1 | CREATE TABLE `student1` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`name` varchar(100) NOT NULL,

`age` int(11) NOT NULL,

`sex` enum('0','1') NOT NULL DEFAULT '0',

`date` int(11) NOT NULL,

PRIMARY KEY (`id`),

KEY `index_name` (`date`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> explain select * from student1 order by date desc limit 10;

+------+-------------+----------+-------+---------------+------------+---------+------+------+-------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+------+-------------+----------+-------+---------------+------------+---------+------+------+-------+

| 1 | SIMPLE | student1 | index | NULL | index_name | 4 | NULL | 1 | |

+------+-------------+----------+-------+---------------+------------+---------+------+------+-------+

1 row in set (0.00 sec)

MariaDB [test]>