1Z0-515 · Question #70
What areas can SQL Access Advisor give advice on?
The correct answer is A. Partitioning advice, index advice, and materialized views advice. The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and materialized views which might improve system performance. Oracle 11g has made two significant changes to the SQL Access Advisor: The advisor now includes advice on partitioning…
Question
What areas can SQL Access Advisor give advice on?
Options
- APartitioning advice, index advice, and materialized views advice
- BIndex advice and compression advice
- CIndex advice and data masking advice
- DPartitioning advice and compression advice
How the community answered
(15 responses)- A80% (12)
- C7% (1)
- D13% (2)
Explanation
The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and materialized views which might improve system performance. Oracle 11g has made two significant changes to the SQL Access Advisor: The advisor now includes advice on partitioning schemes that may improve performance. The original workload manipulation has been deprecated and replaced by SQL tuning sets.
Topics
Community Discussion
No community discussion yet for this question.