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;