【多选题】When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()
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.
【简答题】完型填空。 The earth is our home. We must take care of it. Life today is easier that it was 1 years ago, but it has brought some new problems. One of the biggest problems is pollution. We can see it, drink...
【多选题】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.