oracle 如何”更快的“返回指定行数之间的查询结果？？？

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

现在只知道用 minus ，　

select ... where rownum < 50 minus select ... where rownum < 30 　

但貌似速度好慢，一亿多条数据的库，每次查 500 条数据出来都要几秒

2 replies • 2016-05-11 14:12:48 +08:00

wyj12501

May 11, 2016

select *
from (select rownum rn, a.*
from (select * from XXX where YYY order by ZZZ) a
where rownum < 50)
where rn > 30;

benson458

May 11, 2016

@wyj12501 谢谢，不过越读到后面就变得超慢了