SQL> select * from dba_indexes where table_name='T100' and owner='SYSTEM';SQL> 未选定行 SQL> select * from (select rownum as rn, a.* from (select * from t100 a where object_id > 1500 and owner = 'SYSTEM' order by object_id desc) a where rownum <= 40) a where rn >= 1; SQL> select count(*) from t100 where owner='SYSTEM'; COUNT(*) ---------- 79232 SQL> select count(*) from t100 where owner='SYSTEM' and object_id>1500; COUNT(*) ---------- 71552 ---高级执行计划: 11G: set linesize 200; set pagesize 200; alter session set statistics_level=all; ---再运行SQL SQL> select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST')); S
分页SQL创建索引规则
最新推荐文章于 2024-04-12 13:48:47 发布