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
正确答案:B,C
答案解析:有

微信扫一扫手机做题