Oracle
1Z0-117 · Question #35
You ran a high load SQL statement that used an index through the SQL Tuning Advisor and accepted its recommendation for SQL profile creation. Subsequently you noticed that there has been a 2% growth…
The correct answer is C. It remains and allows the optimizer to pick a different plan required. See the full explanation below for the reasoning.
Question
You ran a high load SQL statement that used an index through the SQL Tuning Advisor and accepted its recommendation for SQL profile creation. Subsequently you noticed that there has been a 2% growth in number of rows in the tables used by the SQL statement and database statistics have also been refreshed. How does this impact the created SQL profile?
Options
- AIt becomes invalid and no longer used the optimizer.
- BIt remains valid and ensures that the optimizer always use the execution plan that was created before
- CIt remains and allows the optimizer to pick a different plan required.
- DIt becomes invalid and a new SQL profile is created for the statement by the auto tuning task.
How the community answered
(52 responses)- A15% (8)
- B4% (2)
- C75% (39)
- D6% (3)
Community Discussion
No community discussion yet for this question.