oracle分页sql优化语句

常规的分页思路：

select *

 from (select a.*, rownum as rnum

         from (select * from burgess) a

        where rownum <=5300)

where rnum >= 5000

有较高效率的分页思路

select *

 from (select *

         from (select b.*, row_number() OVER(ORDER BY null) AS "row_number"

                 from burgess b) p

        where p."row_number" > 5000) q

where rownum <= 300