Page History
...
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. |
...
- 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.