QUESTION 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
Correct Answer: B
名为ord_custname_ix索引已在ORDER表custname列创建
使用下面的命令
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
订单表是经常使用的custname列在WHERE子句的查询。你想要
若不提供索引,则检查查询性能的影响。你不想要的
要删除或重建的索引以执行此测试。
这是最有
效的方法执行这项任务?
B.设置为不可见 就可以