Using Invisible Indexes
Table created. SQL> create index ind_TEST.index_tables on TEST.tables_empty (a) Index created. OWNER OBJECT_NAME OBJECT_TYPE —————————— —————————— ———– TEST TABLES_EMPTY TABLE IND_TEST INDEX_TABLES INDEX SQL> exec dbms_stats.gather_table_stats (ownname=>’TEST’,tabname=>’TABLES_EMPTY’,cascade=>TRUE); PL/SQL procedure successfully completed. SQL> exec dbms_stats.gather_index_stats (ownname=>’IND_TEST’,indname=>’INDEX_TABLES’); PL/SQL procedure successfully completed. SQL> conn ind_TEST Enter password: SQL> explain plan for 2 select * from TEST.TABLES_EMPTY; SQL> @?/rdbms/admin/utlxpls PLAN_TABLE_OUTPUT ———————————————————————– Plan hash value: 932631555 ———————————————————————————- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ———————————————————————————- | 0 | SELECT STATEMENT | | 1 | 13 | 2 (0)| 00:00:01 | | 1 | TABLE...