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.