What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that
selection of SQL plan baselines
partitioning of tables and indexes
creation of index-organized tables
creation of bitmap, function-based, and B-tree indexes
optimization of materialized views for maximum query usage and fast refresh
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.