Sqlserver cache plan-Clear the cache plan that is only used once, And Cache

Sqlserver cache plan-Clear the cache plan that is only used once, And Cache

The plan cache is very large and will only be cleared once using the cache plan, instead of the entire cache. declare @ sid varbinary (64) declare cur01 cursor forselect plan_handle from (SELECT plan_handle FROM sys. dm_exec_cached_plans AS cp cross apply sys. dm_exec_ SQL _text (cp. plan_handle) stWHERE cp. cacheobjtype = n' Compiled Plan 'AND cp. objtype IN (N 'adhoc ', N 'prepared') AND cp. usecounts = 1 and text like 'select % ') copen cur01fetch next from cur01 into @ sidwhile @ fetch_status = 0 beginDBCC FREEPROCCACHE (@ sid) fetch next from cur01 into @ sidendclose export cur01go