What recommendations does the SQL Access Advisor provide for optimizing SQL queries?

What recommendations does the SQL Access Advisor provide for optimizing SQL queries?
(Choose all that apply.)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *