本文深入探讨了在SQL调优过程中，利用现有SQL配置文件更新统计数据的重要性，解释了如何通过配置文件自动收集和更新统计信息，以提高查询效率。详细介绍了SQL配置文件如何与自动统计收集任务协同工作，以及在数据库性能管理和调优中的关键作用。
QUESTION 196
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 byrunning GATHER_STATS_JOB.
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
Answer: B
同298题：http://blog.csdn.net/rlhua/article/details/14090013
Explanation/Reference:
Section: Managing Database Performance & Tuning
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
