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. |
You can copy an execution plan from the Execution Plan pane and paste it into another file as text or a bitmap image.
To copy an execution plan
In an Optimize SQL session (SQL Rewrite or Plan Control), you can execute the original or an alternative SQL statement to retrieve and review the statement's result set.
To retrieve result set
Right-click the selected statement in the Alternatives list (or right-click the SQL text) and select Run Result.
In the Run Result dialog, click . After the script executes, the result set displays in the Result pane of the Run Result dialog.
Tip: Click to copy the SQL statement to execute in another Quest Software product.
To review details for an alternative
Select a Plan Control session.
Select an execution plan alternative in the Plans pane.
Review the details of the alternative in the Execution Plan pane.
Note: You must execute the alternatives before you can review run time statistics. See Test Run Execution Plan Alternatives for more information.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center