Can we remove a single query plan
摘要：Can we remove a single query plan?You can use sp_recompile system stored procedure to clear it if the type of query plan is proc,trigger or functionElse you can't. If the received parameter of sp_reco...
阅读全文
posted @
2009-08-10 16:44
stswordman
阅读(330)
推荐(0) 编辑
sql_handle and plan_handle （读书笔记）
摘要：SET option make different compiled plan
For specific sql test, it always has the same sql_handle, but it may not always have the same plan_handle. If the cache keys change, we'll get a new plan_handle in plan cache. The relationship between sql_handle and plan_handle is thus 1:N
阅读全文
posted @
2009-08-03 11:26
stswordman
阅读(2429)
推荐(0) 编辑
