Oracle 11G OCP 1Z0-053 232

（232）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

答案：（B、D、E）

解析：

提供的解決方法中不包含索引組織表

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1266056/，如需轉載，請註明出處，否則將追究法律責任。