---

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

---

出自：Oracle认证

显示答案