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).
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.
Refer to here.