可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

While tuning a SQL&#


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
参考答案
参考解析:
分类:1Z0-053题库