What recommendations does the SQL Access Advisor provide for optimizing SQL queries?
(Choose all that apply.)
A.
selection of SQL plan baselines
B.
partitioning of tables and indexes
C.
creation of index-organized tables
D.
creation of bitmap, function-based, and B-tree indexes
E.
optimization of materialized views for maximum query usage and fast refresh
Explanation:
Refer to here.
SQL Access Advisor helps you achieve your performance goals by recommending the
proper set of materialized views, materialized view logs, partitions, and indexes for a given
workload.
SQL Access Advisor index recommendations include bitmap, function-based, and B-tree
indexes. SQL Access Advisor materialized view recommendations include fast refreshable
and full refreshable MVs, for either general rewrite or exact text match rewrite.