oracle分页测试

用数据说话：同样的环境下测试4次

//省时分页
select * from(select a.*,rownum rn from (select * from cfma_dms_report) a where rownum<40) where rn>20

耗时：22.4  27.3  22.0  23.2

 

//耗时分
select * from(select a.*,rownum rn from (select * from cfma_dms_report) a ) where rn between 20 and 40 

耗时： 36.09  27.25  28.3  32.1