DBI202Xuất hiện trong 1 đề thi
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?
Các lựa chọn
AUse the WITH RECOMPILE option when creating the stored procedure.
BUse the WITH UPDATE_QUERY_PLAN option when creating the stored procedure.
CRun the RECOMPILE Transact-SQL statement to force a recompile.
DQuery plans are always up to date, so this is not necessary