Listing 5: Creating a Plan Guide for the Cached Plan

USE AdventureWorks
EXEC sp_create_plan_guide
    @name = N'RemovePlan',
    @stmt = N'SELECT * FROM Sales WHERE ContactID < @ID',
    @type = N'SQL',
    @module_or_batch = NULL,
    @params = N'@ID int',
    @hints = N'OPTION(RECOMPILE)';