OCP 1Z0 053 22

22.An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS 
table using the following command: 
SQL>CREATE INDEX ord_custname_ix ON orders(custname); 
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want 
to check the impact on the performance of the queries if the index is not available. You do not want the 
index to be dropped or rebuilt to perform this test. 
Which is the most efficient method of performing this task? 
A. disabling the index 
B. making the index invisible 
C. making the index unusable 
D. using the MONITORING USAGE clause for the index 
Answer: B 

把索引改为不可见后，dml仍然维护该索引，但除非增加hint，select语句中将不使用该索引。直接改为visible。

这样，当你发现必须使用该索引时可以很快的恢复。

http://docs.oracle.com/cd/B28359_01/server.111/b28318/schema.htm#CNCPT1895

Visible and Invisible Indexes

Indexes can be visible or invisible. An invisible index is maintained by DML operations and cannot be used by the optimizer.

Making an index invisible is an alternative to making it unusable or dropping it.