Fill Missing Execution Plans
When you generate virtual index alternatives, SQL Optimizer retrieves virtual execution plans because the indexes are not physically created on the database. You can retrieve execution plans for index alternatives by creating temporary indexes. SQL Optimizer drops the temporary indexes once it retrieves the execution plans.
To fill a missing execution plan
- Click
or
.
-
Select an index alternative in the Alternatives pane. The Virtual Plan tab displays by default in the Execution Plan pane.
- Click the arrow besides
and select Fill Missing Plans. The Execution Plan tab now displays an execution plan.
Fill Missing Estimated Plans
When you generate virtual index alternatives, SQL Optimizer retrieves virtual execution plans because the indexes are not physically created on the database. You can retrieve execution plans for index alternatives by creating temporary indexes. SQL Optimizer drops the temporary indexes once it retrieves the execution plans.
To fill a missing estimated plan
- Click
-
Select an index alternative in the Alternatives pane. The Virtual Plan tab displays by default in the Execution Plan pane.
- Click
Copy Execution Plans
To copy an execution plan
| » | Right-click the execution plan and select Copy. |
Note: You can paste execution plans displayed as a Tree Plan or Plain Language Plan in text or bitmap format. Applications such as Microsoft Word allow you to choose the format using the Paste Special option. You can use text applications such as Notepad to paste execution plans in text format or graphic applications such as MS Paint to paste execution plans in bitmap format.
Animate Execution Plans
You can animate each step in the execution plan in the order SQL Optimizer executes them.
To animate the execution plan or cancel the animation
| » | Right-click the execution plan and select Animate Plan Steps. |