Oracle
1Z0-043 · Question #36
You find that the execution time of reports in your data warehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which…
The correct answer is C. SQL Access Advisor. See the full explanation below for the reasoning.
Question
You find that the execution time of reports in your data warehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to, in order to determine the appropriate indexes?
Options
- AMemory Advisor
- BSegment Advisor
- CSQL Access Advisor
- DAutomatic Workload Repository (AWR)
- EAutomatic Database Diagnostic Monitor (ADDM)
How the community answered
(32 responses)- A9% (3)
- B3% (1)
- C84% (27)
- E3% (1)
Community Discussion
No community discussion yet for this question.