053-7 When executing a SQL workload, you choose to generate execution plans only, without collecting

QUESTION 7
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.
Correct Answer: AC
Section: (none)
Explanation

A 只产生执行计划可以更少的去计算结果

B 不用调用优化器

C 同时减少对系统资源的影响

D 会稍微影响点性能的