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:
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?