Oracle
1Z0-417 · Question #54
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
The correct answer is B. Stored Outlines. SQL statement, or migrate an existing stored outline by loading the "outlined" plan as a fixed https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm
SQL Tuning
Question
Which is used to preserve SQL execution plans of existing statements when moving from one version of the database to another?
Options
- ASQL Hints
- BStored Outlines
- CStored Profiles
- DSQL Plan Management
- ESQL Profiles
How the community answered
(36 responses)- A11% (4)
- B81% (29)
- C6% (2)
- E3% (1)
Explanation
SQL statement, or migrate an existing stored outline by loading the "outlined" plan as a fixed https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm
Topics
#stored outlines#SQL plan stability#plan preservation#database upgrade
Community Discussion
No community discussion yet for this question.