Review Query Plans
The query plan can be displayed in different ways to help you get a clear picture of or detailed information about the steps that Adaptive Server is taking to execute the SQL statement.
Note: These different display modes are only available when you are connected to Adaptive Server 15.0 or later.
To change how the query plan displays
-
Right-click the Query Plan window and select View Plan.
-
Select one of the following display options.
- As Tree Plan
- As Plain Language Plan
- As Graphic Plan
- As MS Graphic Plan
- As Text
- As XML
When you are viewing the query plan as Tree Plan or as Plain Language Plan, the following functions are available from the button pane at the right edge of the query plan.
| Button | Action | Description |
|
|
Go to First Step |
Highlights the first execution step. |
|
|
Go to Previous Step |
Highlights the previous execution step. |
|
|
Go to Next Step |
Highlights the next execution step. |
|
|
Show Plan Detail |
Displays the Plan Detail window. The information displayed is dependent on the highlighted row. |
