407.Which of the following is a potential performance tuning recommendation from the SQL Access
Advisor?
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
Answer: E
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94876
Using SQL Access Advisor in Enterprise Manager or API, you can do the following:
-
Recommend materialized views and indexes based on collected, user-supplied, or hypothetical workload information.
-
Recommend partitioning of tables, indexes, and materialized views.
-
Mark, update, and remove recommendations.
In addition, you can use SQL Access Advisor API to do the following:
-
Perform a quick tune using a single SQL statement.
-
Show how to make a materialized view fast refreshable.
-
Show how to change a materialized view so that general query rewrite is possible.