(Choose 1 answer)
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?
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
Exi Q: 40
