Which two statements describe the implications of this?

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.)

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Eamon

Eamon

Answer C is correct
I suggest reading …
http://oracle.su/docs/11g/server.112/e12254/spa_intro.htm#CHDGHFGI

The best of the rest of the answers is A, I say this because if you keep reading the above you will come across the following….
If you chose to generate explain plans only in the SQL trials, then SQL Performance Analyzer will use the optimizer cost stored in the SQL execution plans.