2. |
Alison wants to make sure that her query plan is guaranteed to be up to date when executing a stored procedure. She does not mind
if it takes longer to execute that stored procedure. How can she ensure this?
Please select the best answer.
|
|
A.
|
Use the WITH RECOMPILE option when creating the stored procedure.
|
|
B.
|
Use the WITH UPDATE_QUERY_PLAN option when creating the stored procedure.
|
|
C.
|
Run the RECOMPILE Transact-SQL statement to force a recompile.
|
|
D.
|
Query plans are always up to date, so this is not necessary.
|