1Z0-053 V13.02 Q691

691. You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few most resource-intensive statements.
What must you do to receive recommendations on efficient use of indexes and materialized views to improve query performance?
A.Run the SQL Access Advisor.
B.Run the SQ; Tuning Advisor (STA).
C.Run the Automatic Workload Repository (AWR) report.
D.Run the Automatic Database Diagnostic Monitor (ADDM).
Answer:A

参考： http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94878

你必须做什么来获得建议有效地使用索引和物化视图提高查询性能？
SQL访问顾问是一个ADDM诊断指导，提供额外的支持，找出潜在的修改架构。这些潜在的模式可以用来减少I/O，CPU，和等待时间的总量对于一个给定的SQL语句。
指导也对潜在的有关索引和物化视图提出建议，提高系统的性能。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2124532/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2124532/