Oracle
1Z0-054 · Question #191
View the Exhibit and examine the plans in the SQL plan baseline.You observe that the last two SELECT statements (outlined in red and blue) are identical, but have two different plans. Also, the…
The correct answer is B. Use SQL Tuning Advisor to tune the plan. D. Use the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to evolve the plan. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the plans in the SQL plan baseline.You observe that the last two SELECT statements (outlined in red and blue) are identical, but have two different plans. Also, the second plan (in blue) is not being used by the optimizer. Which two steps do you perform to ensure that the optimizer uses the second plan (in blue) if the plan is more efficient? (Choose two.)
Exhibit
Options
- AMark the second plan (in blue) as fixed.
- BUse SQL Tuning Advisor to tune the plan.
- CUse SQL Access Advisor to tune the plan.
- DUse the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to evolve the plan.
How the community answered
(28 responses)- A7% (2)
- B82% (23)
- C11% (3)
Community Discussion
No community discussion yet for this question.