SQL> set linesize 200
SQL> set pagesize 200
SQL> alter session set statistics_level=all;
Session altered.
SQL> select * from ( select rownum as rn ,a.* from ( select
* from page a )a where rownum<=20 ) a where rn>=0 2 ;
20 rows selected.
SQL> select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------
SQL_ID axby03b75am6v, child number 0
-------------------------------------
select * from ( select rownum as rn ,a.* from ( select * from page a
)a where
全表扫描分页
最新推荐文章于 2022-04-18 09:55:14 发布
这篇博客探讨了如何使用SQL进行全表扫描的分页查询,通过示例展示了如何选择前20行和第2页(21-40行)的数据,并分析了查询计划,揭示了在分页查询中可能的效率问题和解决方案。
摘要由CSDN通过智能技术生成