What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()
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
正确答案
答案解析
相似试题
(多选题)
What are four benefits of recommended basic architecture?()
(多选题)
What two statements are true regarding the recommendations received from the SQL Access Advisor?()
(多选题)
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()
(单选题)
A customer claims that while redeploying a web application in the production system all their customers are having to log in again. What do you recommend? ()
(多选题)
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()
(单选题)
What does the SCN represent?()
(单选题)
What does the SCN represent?()
(单选题)
What is an obsolete backup set?()
(多选题)
What are three benefits of using ASM?()