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…

Question

Options

• ARewrite all the queries in the application to identify materialized view
• BRewrite existing queries. New queries will automatically use the views.
• CRespond positively to the Advisor to create the materialized views.
• DBuild virtual views on a third normal form schema.

• A
  12% (3)
• B
  8% (2)
• C
  77% (20)
• D
  4% (1)

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.

No community discussion yet for this question.