Oracle 11g之不可见的索引(三)
--------------
2 DYLAN
执行计划
----------------------------------------------------------
Plan hash value: 1389866015
----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 25 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| TEST | 1 | 25 | 2 (0)| 00:00:01 |
|* 2 | INDEX RANGE SCAN | TEST_IDX | 1 | | 1 (0)| 00:00:01 |
----------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("NAME"='DYLAN')
Note
-----
- dynamic sampling used for this statement (level=2)
SCOTT@chan> select visibility
2 from user_indexes
3 where index_name = 'TEST_IDX';
VISIBILIT
---------
INVISIBLE
--------------------------
Present By Dylan.