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?
A. It becomes invalid and no longer used the optimizer.
B. It remains valid and ensures that the optimizer always use the execution plan that was created before the changes happened.
C. It remains and allows the optimizer to pick a different plan required.
D. It becomes invalid and a new SQL profile is created for the statement by the auto tuning task.
|
Download Printable PDF. VALID exam to help you PASS. |
 |