You have analyzed your client’s workload and the SQL Access Advisor in Enterprise Manager
recommends that you create some materialized views to improve performance. What should you
do in order to most simply implement this change?
A.
Rewrite all the queries in the application to identify materialized view
B.
Rewrite existing queries. New queries will automatically use the views.
C.
Respond positively to the Advisor to create the materialized views.
D.
Build virtual views on a third normal form schema.
Explanation:
Enterprise Manager provides a very simple interface for the SQL Access Advisor
(Advisor Central > SQL Advisor >SQL Access Advisor). The first page allows you to create tasks
to test existing indexes, materialized view and partitions, or create tasks to suggest new
structures.
The “Workload Source” page allows you to define the workload to associate with the task. The
basic options allow the workload to be gathered from the cursor cache, an existing SQL tuning set,
or a hypothetical workload based on specific schema objects.
The “Recommendation Options” page allows you to define which type of recommendations you
are interested in (Indexes, Materialized Views and Partitioning).
After reviewing the result of the analysis you can decide if you should accept or ignore the
suggested recommendations.
Note: The SQL Access Advisor was introduced in Oracle 10g to make suggestions about
additional indexes and materialized views which might improve system performance.Reference: QL Access Advisor in Oracle Database 11g Release 1
http://www.oracle-base.com/articles/11g/SQLAccessAdvisor_11gR1.php
C