Question : I created a plan guide using the following query: EXEC sp_create_plan_guide @name = N’Entity_Property fix’, @stmt = N’SELECT […]
Tag: plan-guides
SQL Server Plan Guide
Question : I have a query that needs a plan guide, but I am having a hard time setting it […]
SQL Guide Plan not being used?
Question : I’m try to get force Parameterization on a simple adhoc SQL query.As explained in this article https://www.simple-talk.com/sql/performance/fixing-cache-bloat-problems-with-guide-plans-and-forced-parameterization/ But […]
Does Query Plan cache gets cleared by itself?
Question : I have been working on query plan stored in plan cache and every time i search for a […]
Does Query Plan cache gets cleared by itself?
Question : I have been working on query plan stored in plan cache and every time i search for a […]
Unable to use plan guide with sp_execute
Question : I have an application that’s querying a 10 million rows table. The query is filtering by an integer […]
Does plan recompilation happens to plan guide?
Question : Does plan recompilation happens for plan guide due to the, for example, auto update stats? P.S Do not […]