Plan guide for associating query

sp_create_plan_guide creates a plan guide for associating query hints or actual query plans with queries in a database.

EXEC sp_create_plan_guide 

    @name =  N'Guide1',

    @stmt = N'SELECT *

              FROM Sales.SalesOrderHeader AS h 

              INNER JOIN Sales.Customer AS c 

                 ON h.CustomerID = c.CustomerID

              INNER JOIN Sales.SalesTerritory AS t 

                 ON c.TerritoryID = t.TerritoryID

              WHERE t.CountryRegionCode = @Country_region',

    @type = N'OBJECT',

    @module_or_batch = N'Sales.GetSalesOrderByCountry',

    @params = NULL,

    @hints = N'OPTION (OPTIMIZE FOR (@Country_region = N''US''))';

EXEC sp_create_plan_guide 

    @name = N'Guide1', 

    @stmt = N'SELECT TOP 1 * 

              FROM Sales.SalesOrderHeader 

              ORDER BY OrderDate DESC', 

    @type = N'SQL',

    @module_or_batch = NULL, 

    @params = NULL, 

    @hints = N'OPTION (MAXDOP 1)';

http://msdn.microsoft.com/en-us/library/ms179880.aspx

sp_control_plan_guide drops, enables, or disables a plan guide.

EXEC sp_control_plan_guide N'DROP', N'Guide1'

http://msdn.microsoft.com/en-us/library/ms188733.aspx