487.When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this? (Choose two.)
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
Answer: AC
执行SQL工作量的时候,你选择生成执行计划,而不执行数据收集。哪两个陈述描述了这一影响?
A、它产生不太准确的结果的比较分析。
C、缩短了执行时间,减少了对系统资源的影响。
Which two statements describe the implications of this? (Choose two.)
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
Answer: AC
执行SQL工作量的时候,你选择生成执行计划,而不执行数据收集。哪两个陈述描述了这一影响?
A、它产生不太准确的结果的比较分析。
C、缩短了执行时间,减少了对系统资源的影响。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81227/viewspace-2124442/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81227/viewspace-2124442/