Oracle
1Z0-514 · Question #32
You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best…
The correct answer is D. use deferred publishing of statistics to allow you to test execution plans before making the statistics. See the full explanation below for the reasoning.
Question
You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best course of action would be to:
Options
- Arefrain from collecting statistics
- Buse Real Application Testing to capture the workload and the worked and then run the worked on a
- Cuse hints to create fixed plans for SQL statements
- Duse deferred publishing of statistics to allow you to test execution plans before making the statistics
- Euse invisible indexes to dominate execution plans
How the community answered
(52 responses)- A4% (2)
- B8% (4)
- C12% (6)
- D75% (39)
- E2% (1)
Community Discussion
No community discussion yet for this question.