深入探讨Oracle11g中SQL访问顾问如何生成关于分区、索引创建、物化视图及物化视图日志的优化建议。通过分析工作负载和指定信息，该工具为表和索引分区提供指导，而不涉及统计收集建议。
QUESTION 161
In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
Answer: ACDE
同262题：http://blog.csdn.net/rlhua/article/details/19037831
Explanation/Reference:
Section: Managing Database Performance & Tuning
In Oracle 11g, the SQL Access Advisor can generate partitioning recommendations, index creation
recommendations, materialized view recommendations,and materialized view log recommendations. The SQL
Access Advisor is a tuning tool that provides advice regarding the tuning of materialized views, indexes(Btree,
bitmap, and function-based), and materialized view logs, as well as advice on table and index partitioning.
The SQL Access Advisor provides recommendations by analyzing a known workload and other specified
information. SQL Access Advisor does not generate statistics collection recommendations. This task is
performed by the SQL Tuning Advisor.
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
