Oracle
1Z0-054 · Question #31
1Z0-054 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Question
You plan to collect statistics for an important table in your database to help improved query performance. You are uncertain about the optimizer behavior after the statistics have been collected because currently there are no statistics for indexes or partitions on the table. You wish to test the performance effect of the newly collected statistics. How would you prevent the optimizer from using the newly collected statistics for other sessions immediately after statistics collection?
Options
- ASet the PUBLISH preference to FALSE for the table.
- BSet the NO_VALIDATE preference to TRUE for the table.
- CSet the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.
- DSet the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter to FALSE for the session.
- ESet the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE for the session.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.