This tab displays any existing plan guides on the server for the statements being tuned. This can be useful when trying to determine whether a plan guide is, or should be, used for a query, or conversely, finding plan guides that have become obsolete.
In addition to the Enabled and Drop controls, each plan guide entry on the tab shows columns corresponding to the sp_create_plan_guide
call arguments the plan guide was created with.
Column | Description |
---|---|
Name | The name given the plan guide when it was created. |
Statement | The text of the Transact-SQL statement |
Type | The type of entity in which the statement occurs:
|
Module/Batch | Specifies either the name of the object in which the statement occurs or the batch text in which the statement appears. |
Parameters | Specifies the definitions of all parameters in the statement. |
Hints | Can be one of the following:
|
For a detailed understanding of the Parameters and Hints values, particularly when using the edit plan guide functionality described below, see the Microsoft SQL Server documentation. |
You can modify any plan guide listed on the Plan Guides tab. You can enable or disable the plan guide, drop it, or specify parameters or hints.
To drop a plan guide
To enable or disable a plan guide
To edit a plan guide
@params = argument
@hints = argument
| | | | | | | |