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