mysql 的 limit 优化

This topic created in 3189 days ago, the information mentioned may be changed or developed.

下面两个语句

select phone from user  where id >(select id from user limit 3000000,1) order by id limit 0,10;

select phone from user  order by id limit 3000001,10;

测试多次，第一个总是比第二个好，索引都是主键 id 为何会有区别？

1 replies • 2017-09-11 23:48:02 +08:00

guyeuro

Sep 11, 2017

顶顶顶！