Page History
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:
|
Info |
---|
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
- Select the Drop check box for that plan guide entry and then click the Apply button ( ) on the far right of the tab.
To enable or disable a plan guide
- Enable by selecting the Enabled check box (or deselect Enabled to disable) for the plan guide entry and then click the Apply button ( ) on the far right of the tab.
To edit a plan guide
- Right-click a plan guide entry and select Edit to open the Edit Plan Guide.
- In the Parameters field, provide a valid sp_create_plan_guide stored procedure call
@params = argument
- In the Hints field, provide a valid sp_create_plan_guide stored procedure call
@hints = argument
- Click Next to preview the generated stored procedure calls.
- Click Finish.