1Z0-054 · Question #34
You observe that suboptimal execution plans for the queries are being generated on a table that previously used less resources. You have collected statistics on these tables two days ago. The…
The correct answer is A. restoring statistics from statistics history up to the desired time. See the full explanation below for the reasoning.
Question
You observe that suboptimal execution plans for the queries are being generated on a table that previously used less resources. You have collected statistics on these tables two days ago. The optimizer statistics retention period is set to 31 days. You are able to find the timestamp information about statistics update from the DBA_TAB_STATS_HISTORY view. Because it is a frequently queried table, you would like the optimizer to generate better plans. Which action would enable you to use the previous set of statistics on the objects that may lead to better execution plans?
Options
- Arestoring statistics from statistics history up to the desired time
- Bdeleting all AWR snapshots collected after the time of desired statistics collection
- Capplying the flashback table technique until the time of desired statistics collection
- Dsetting the OPTIMIZER_PENDING_STATISTICS parameter to TRUE to use the previous version
How the community answered
(48 responses)- A73% (35)
- B8% (4)
- C15% (7)
- D4% (2)
Community Discussion
No community discussion yet for this question.