Sample Header Ad - 728x90

Exclamation point on plan guide

6 votes
1 answer
1499 views
I created a plan guide using the following query: EXEC sp_create_plan_guide @name = N'Entity_Property fix', @stmt = N'SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value FROM jirascheme.entity_property WHERE ENTITY_NAME=@P0 AND ENTITY_ID=@P1 AND PROPERTY_KEY=@P2', @type = N'SQL', @params = N'@P0 nvarchar(255), @P1 numeric(18, 0), @P2 nvarchar(255)', @hints = N'OPTION (OPTIMIZE FOR UNKNOWN)'; It seems to work fine, but I noticed that there is a little warning icon on the plan in Object Explorer. It looks like this: plan guide warning icon I don't get any warnings when executing the query, and I can't find any information about it when hovering over it or checking the properties of the plan guide. This is only applied in a test environment but why does it show up and should I be worried about it?
Asked by FLeX (163 rep)
Jan 24, 2019, 02:32 PM
Last activity: Feb 20, 2019, 03:10 PM