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 initiates the statistics collection process by running GATHER_STATS_JOB.
B.
It makes the statistics information available to GATHER_STATS_JOB.
C.
It updates the existing SQL profiles with current statistics.
D.
It logs a warning message in the alert log so that the DBA can perform statistics
collection manually.