单选题

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?()

AIt updates the existing SQL profiles with current statistics

BIt makes the statistics information available to GATHER_STATS_JOB

CIt initiates the statistics collection process by running GATHER_STATS_JOB

DIt logs a warning message in the alert log so that the DBA can perform statistics collection manually

正确答案

来源:www.examk.com

答案解析