本文深入探讨了SQL访问顾问的推荐策略，包括其在多工作负载查询支持、分区建议、不同类型索引推荐等方面的功能。
18
What two statements are true regarding the recommendations received from the SQL Access Advisor?
(Choose two.)
A. It cannot generate recommendations that support multiple workload queries.
B. It can recommend partitioning on tables provided that the workloads have some predicates and joins
on the columns of the NUMBER or DATE type.
C. It can recommend partitioning only on tables that have at least 10,000 rows.
Section: (none)
Explanation
Explanation/Reference:
What two statements are true regarding the recommendations received from the SQL Access Advisor?
(Choose two.)
A. It cannot generate recommendations that support multiple workload queries.
B. It can recommend partitioning on tables provided that the workloads have some predicates and joins
on the columns of the NUMBER or DATE type.
C. It can recommend partitioning only on tables that have at least 10,000 rows.
D. It can recommend only B-tree indexes and not bitmap or function-based indexes.
Section: (none)
Explanation
Explanation/Reference:
扫一扫
3387
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
