分页SQL创建索引规则

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