QUESTION NO: 433
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
Answer: B,D,E
关于SQL访问顾问提供优化SQL查询有什么建议?
B.表和索引的分区
D.位图、基于函数的和B树索引的创建
E.用于最大查询使用和快速刷新的物化视图优化