While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the
statement that has stale statistics available. What would the optimizer do in this situation?
A.
It logs a warning message in the alert log so that the DBA can perform statistics
collection manually.
B.
It initiates the statistics collection process by running GATHER_STATS_JOB.
C.
It updates the existing SQL profiles with current statistics.
D.
It makes the statistics information available to GATHER_STATS_JOB.