select * from rental a inner join (
select rental_id from rental where createDate > '2022-02-19 10:20:07' order by createDate limit 100000, 10
) b on a.rental_id=b.rental_id;
说明:createDate 列上有btree索引,且是聚簇索引,rental_id 是主键索引
select * from rental a inner join (
select rental_id from rental where createDate > '2022-02-19 10:20:07' order by createDate limit 100000, 10
) b on a.rental_id=b.rental_id;
说明:createDate 列上有btree索引,且是聚簇索引,rental_id 是主键索引