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
答案解析:有
微信扫一扫手机做题