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 resourceintensive 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).
Explanation:
In addition, SQL Access Advisor can recommend partitioning on an existing unpartitioned base table to improve
performance. Furthermore, it may recommend new indexes and materialized views that are themselves
partitioned. While creating new partitioned indexes and materialized view is no different from the unpartitioned
case, partitioning existing base tables should be executed with care. This is especially true when indexes,
views, constraints, or triggers are defined on the table. See “Special Considerations when Script Includes
Partitioning Recommendations” for a list of issues involving base table partitioning for performing this task
online.