ORACLE分页SQL语句

wfworkitem表共：64万条数据

1 根据rowid查询：

   select * from wfworkitem w where rowid in( select rid from ( select rownum rm, rid from ( select rowid rid , wfworkitemid from wfworkitem order by wfworkitemid desc) where rownum < 100000 ) where rm > 99800) order by w.wfworkitemid desc

  测试结果：第一次查询在2秒左右，之后查询在0.05秒左右

2 根据rownum查询

select * from ( select w2.* , rownum rn from (select * from wfworkitem w1 order by w1.wfworkitemid desc) w2 where rownum < 100000) where rn > 99800

测试结果：第一次查询在3秒左右，之后查询在1.5秒左右