What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
A. Force the query execution plan for plan 1221065.
B. Run the DBCC FREEPROCCACHE command.
C. Force the query execution plan for plan 1220917.
D. Disable parameter sniffing.
Answer:C
What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
A. Force the query execution plan for plan 1221065. B. Run the DBCC FREEPROCCACHE command. C. Force the query execution plan for plan 1220917. D. Disable parameter sniffing.