分页查询还有一个很明显的特点,就是处理的页数越小,效率就越高,越到后面,查询速度越慢。
type 1: 大多数情况下优于type2
select *
from
(
select temp.*, ROWNUM rn
from (select * from tablename) temp
where ROWNUM <= endRow
)
where rn >= startRow
type 2:
select *
from
(
select temp.*, ROWNUM rn
from (select * from tablename) temp
)
where rn between startRow and endRow
type 1: 大多数情况下优于type2
select *
from
(
select temp.*, ROWNUM rn
from (select * from tablename) temp
where ROWNUM <= endRow
)
where rn >= startRow
type 2:
select *
from
(
select temp.*, ROWNUM rn
from (select * from tablename) temp
)
where rn between startRow and endRow