Oracle
1Z0-417 · Question #82
Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles, and partitions for a specific workload use?
The correct answer is D. SQL Access Advisor. SQL Access Advisor)
SQL Tuning
Question
Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles, and partitions for a specific workload use?
Options
- ASQL Performance Analyzer
- BTop SQL
- CSQL Tuning Advisor
- DSQL Access Advisor
- EWorkload Advisor
How the community answered
(34 responses)- A3% (1)
- B6% (2)
- C6% (2)
- D71% (24)
- E15% (5)
Explanation
SQL Access Advisor)
Topics
#SQL Access Advisor#materialized views#index recommendations#workload optimization
Community Discussion
No community discussion yet for this question.