Oracle 有类似Mysql的性能分析方法:
create index INDEX_IPHONE_SESSION on table_name(id);
explain plan for select *from table_name order by id desc;
select * from table(dbms_xplan.display);
Oracle 使用rownum between and
select name, price
from (
select rownum r, name, price
from items
)
where r > 5 and
r < 11;
也可以使用Order bye来排序,不过数据将和原来查询出顺序不一样。。。