oracle分页

		
oracle分页
 
1）rownum分页（由oracle分配）慢十倍
  www.zzzyk.com  
    1.(select a1.*,rownum rn from (select * from emp) a1 where rownum<=10);
 
    2.select * from (select a1.*,rownum rn from (select * from emp) a1 where rownum<=10) where rn>=6;
 
    3.select * from (select a1.*,rownum rn from (select name,address from emp) a1 where rownum<=10) where rn>=6;//只需修改最里层字段即可限制
 
2)ROWID来分最快！  www.zzzyk.com  
 
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<1000) where rn>500) order by cid desc;
 
3)函数（over）慢100倍
						
		
	

上一个：oracle存储过程中定义数组变量
下一个：Oracle 10g RAC spfile的基本管理