Use this page to view the properties of plan guides in the selected database. This page is accessed by right-clicking an existing plan guide and clicking Properties.
Plan guides influence query optimization by attaching query hints or a fixed query plan to them. In the plan guide, you specify the Transact-SQL statement that you want optimized and either an OPTION clause that contains the query hints you want to use or a specific query plan you want to use to optimize the query. When the query executes, the query optimizer matches the Transact-SQL statement to the plan guide and either attaches the OPTION clause to the query at run time or uses the specified query plan.
Displays the query hints or query plan to be applied to the Transact-SQL statement. When a query plan is specified as a hint, the XML Showplan output for the plan is displayed.
Displays the status of the plan guide. Possible values are True and False.
Displays the name of the plan guide.
When the scope type is SQL or TEMPLATE, displays the name and data type of all parameters that are embedded in the Transact-SQL statement.
Displays the batch text in which the Transact-SQL statement appears.
Scope object name
When the scope type is OBJECT, displays the name of the Transact-SQL stored procedure, user-defined scalar function, multistatement table-valued function, or DML trigger in which the Transact-SQL statement appears.
Scope schema name
When the scope type is OBJECT, displays the name of the schema in which the object is contained.
Displays the type of entity in which the Transact-SQL statement appears. This specifies the context for matching the Transact-SQL statement to the plan guide. Possible values are OBJECT, SQL, and TEMPLATE.
Displays the Transact-SQL statement against which the plan guide is applied.