Tag Archives: How to clear a Plan handle for a particular SQL statement ? How to get plan_handle for a particular query and how to clear that ? How us supply plan handle with DBCC FREEPROCCACHE

Executing DBCC FREEPROCCACHE with parameters

DBCC FREEPROCCACHE, is used to clear all plan cache, which forces that every stored procedure will be recompiled  on it’s first execution to build a execution plan. This was known fact, till SQL Server 2005, DBCC FREEPROCCACHE has a server wide scope, means we can not clear a specific plan, this limitation was removed in [...]