Which two statements describe the consequences?

While deploying a new application module, the software vendor ships the application
software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences? (Choose two.)

While deploying a new application module, the software vendor ships the application
software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences? (Choose two.)

A.
The plan baselines can be evolved over time to produce better performance.

B.
The newly generated plans are directly placed into the SQL plan baseline without being
verified.

C.
The new SQL statements initially run with the plans that are known to produce good
performance under standard test configuration.

D.
The optimizer does not generate new plans for the SQL statements for which the SQL
plan baseline has been imported.



Leave a Reply 0

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