You are administrating a database that supports an OLTP workload. A new application module is deployed that is shipped along with the SQL plan baselines for the SQL statements executed by the application. You load the SQL plan baselines to the SQL Management Base.

Examine the parameters:

Which two statements are true in this scenario?

Select all that apply.

• A

  The SQL plan baselines are used but better execution plans may be found and can be evolved manually for the SQL statements.

• B

  The SQL plan baselines are used by the SQL statements and ensure that the best plan is used.

• C

  The SQL plan baselines are not used by the SQL statements if the optimizer statistics are stale.

• D

  The SQL plan baselines are loaded but are not used until SQL profiles are generated for the SQL statements.