Deploy Plan Guides
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.To deploy a plan guide
- Select the SQL Details tab in the main window.
- Select a Plan Control Session.
-
Click
and select the alternative from the Select a Plan to Deploy list.
Note: You can also right-click the alternative you want to deploy as a plan guide in the Alternatives pane and select Deploy Plan Guide.
-
Review the following for additional information:
Deploy Description Select a plan to deploy
Click and select an execution plan alternative to deploy.
Performance Comparison Description Mark the plan as
Review the following for additional information:
- Enabled—Select whether to enable or disable this plan.
- Fixed—Select whether to deploy this plan as fixed or non-fixed.
- Not Auto-Purged—Select whether to auto-purge when it is not used.
Plan name
Enter a name for the plan. Description
Enter a description for this plan. -
Click
.