Question

What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL?

(a) DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ]

(b) DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ]

(c) DBCC FREEPROCCACHE [ ( { sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ]

(d) None of the mentioned

This question was posed to me by my school teacher while I was bunking the class.

I want to ask this question from Query Plan Reuse topic in portion Performance Tuning and Optimization of SQL Server

Answer 1

Right choice is (b) DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ]

Explanation: DBCC FREEPROCCACHE removes all elements from the plan cache, removes a specific plan from the plan cache by specifying a plan handle or SQL handle, or removes all cache entries associated with a specified resource pool.