mysql order by 索引 问题

mysql order by  索引：

知道的大神求解啊。另外order by 效率问题有没有解决方案啊，求分享

直接 上sql、结果：

环境：mysql 6.0、wind7 64、

ddl:

CREATE TABLE `compan` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `companyName` varchar(255) DEFAULT NULL,

  `createTime` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `createTime` (`createTime`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=4718521 DEFAULT CHARSET=utf8;

EXPLAIN select * from company  ORDER BY createTime ASC limit 43838,1; 

EXPLAIN select * from company  ORDER BY createTime ASC limit 43839,1; 

转载于:https://my.oschina.net/douxia/blog/288584