053-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).