What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

You have SQL Server on an Azure virtual machine that contains a database named DB1.

You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:

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.

View Answer

Answer: C

Explanation:

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-scenarios