Oracle分页

1.按ROWID来分
select * from t-xiaoxi where rowid in (select rid from
（select rownum rn,rid from (select rowid, rid,cid from
t_xiaoxi order by cid desc) where rownum<10000）where
rn>9980) order by cid desc;
执行时间为0.03秒
2.按分析函数来分
select * from (select t.* ,row_number() over(order by cid
desc ) rk from t_xiaoxi t ) where rk<10000 and rk>9980;
执行时间为1.01 秒
www.2cto.com
3.按ROWNUM 来分
select * from (select t.* ,rownum rn from (select * from
t_xiaoxi order by cid desc ) t where rownum<10000) where
rn>9980 ;
执行时间为0.1秒
其中—t_xiaoxi 为表名，cid为表的关键字段，取按CId降序排序
后的第9981-9999条记录，t_xiaoxi 表中有70000多条记录.