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.
正确答案:B
答案解析:有
微信扫一扫手机做题