摘要：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... 阅读全文

摘要：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 阅读全文