You can have the steps in the execution plan highlighted one-by-one in the order they are executed.
To animate the plan or cancel the animation
You can copy the query plan to the clipboard.
To copy a query plan
Right-click the Query Plan window and select Copy.
When the query plan displays as Tree Plan and Plan Text Language the query plan can be pasted as text or as a bitmap picture. Graphic applications, such as MS Paint, only paste the query plan as a bitmap. Text applications, such as Notepad, only paste it in a text format. Applications that handle both text and graphics, such as Microsoft Word, allow you to choose the format if you select the Paste Special option to paste the image. This option is usually found on the Edit menu.
The Plan Detail window provides detailed information on the selected branch of the query plan. This window is opened in two different ways depending on which display view you have selected for the query plan.
To view the Plan Detail – if you are viewing the query plan as Tree Plan, Plain Language Plan, Graphic Plan, or Microsoft Graphic Plan
Select the query plan step.
Click Plan Detail .
To view the Plan Detail – if you are viewing the query plan as Text
Click the query plan step.
Note: Help | Show Plan Detail must be selected. If you clear this menu option, then the Plan Detail will not be displayed in the Text view of the query plan.
The Plan Detail provides the following information on each branch of the query plan:
Item | Description |
Text of the transact-SQL statement. | |
PhysicalOp |
Physical implementation algorithm for the node. |
Relational algebraic operator for the node. | |
Argument |
Supplemental information about the operation being performed, the content depends on the physical operator. |
A list of values introduced by the operator. | |
EstimateRows |
Estimated number of output rows by the operator. |
EstimateIO |
|
EstimateCPU |
|
Estimated average row size (in bytes) of the row being passed through the operator. | |
Cumulated estimated cost of the operation and all child operation. | |
OutputList |
List of columns being projected by the operation. |
Warnings |
List of warning messages related to the operation. |
Type |
Node type. |
Indicator of whether the operator is running in parallel (0 represents the operator is not running in parallel, while 1 represents the operator is running in parallel). | |
EstimateExecutions |
Estimated number of times the operator will be executed while running the current query. |
The Plan Detail also provides detailed information about the table and views used by the SQL statement.
To see the table or view details
Click the table or view name in the left pane of the Plan Detail window.
Click one of the five tabs at the bottom of the right pane to see specific information about the definition, columns, indexes, constraints/key or data for the table or view.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center