1、MyISAM在通过主键排序时没有用到索引,而是直接用的文件排序
mysql> alter table edu_text engine=myisam;
Query OK, 5 rows affected (0.23 sec)Records: 5 Duplicates: 0 Warnings: 0
mysql> explain select id,title,time from edu_text order by id;
+----+-------------+----------+------+---------------+------+---------+------+------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------+------+---------------+------+---------+------+------+----------------+
| 1 | SIMPLE | edu_text | ALL | NULL | NULL | NULL | NULL | 5 | Using filesort |
+----+-------------+----------+------+---------------+------+---------+------+------+----------------+
1 row in set (0.00 se