Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

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

  1. Right-click the Query Plan window and select View Plan.

  2. 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

image\B_GoToFirstStep.gif

Go to First Step

Highlights the first execution step.

image\B_GoToPreviousStep.gif

Go to Previous Step

Highlights the previous execution step.

image\B_GoToNextStep.gif

Go to Next Step

Highlights the next execution step.

image\B_ShowPlanDetail.gif

Show Plan Detail

Displays the Plan Detail window. The information displayed is dependent on the highlighted row.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating