Generate Execution Plan Alternatives
Plan Control sessions optimize your SQL statement by generating execution plan alternatives for the statement. You can then select an alternative execution plan for your SQL statement and deploy it as a plan guide to improve database performance.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To generate execution plan alternatives
-
Select the Optimize SQL tab in the main window.
-
Select Plan Control from the Optimize SQL start page.
Note: If the start page does not display, click the arrow beside
and select New Plan Control Session.
-
Enter a SQL statement in the Original SQL pane.
- Click
to retrieve the execution plan for your SQL statement. The Select Connection window displays.
- Select a connection.
- Click
to generate execution plan alternatives.