试题详情
多项选择题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）

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.

  • B,C

  • 关注下方微信公众号，在线模考后查看

热门试题