Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Animate Query Plans

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

  1. Right-click the Query Plan window and select View Plan | As Tree Plan or As MS Graphic Plan.
  2. Right-click the Query Plan window and select Animate Plan Steps.

 

Related Topics

Copy Query Plans

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.

 

Related Topics

Plan Detail

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

  1. Select the query plan step.

  2. Click Plan Detail image\B_PlanDetail.gif.

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

StmtText

Text of the transact-SQL statement.

PhysicalOp

Physical implementation algorithm for the node.

LogicalOp

Relational algebraic operator for the node.

Argument

Supplemental information about the operation being performed, the content depends on the physical operator.

DefinedValues

A list of values introduced by the operator.

EstimateRows

Estimated number of output rows by the operator.

EstimateIO

Estimated I/O cost for the operator.

EstimateCPU

Estimated CPU cost for the operator.

AvgRowSize

Estimated average row size (in bytes) of the row being passed through the operator.

TotalSubtreeCost

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.

Parallel

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.

Table/View Detail

The Plan Detail also provides detailed information about the table and views used by the SQL statement.

To see the table or view details

  1. Click the table or view name in the left pane of the Plan Detail window.

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

 

Related Topics

Search Menu

Related Documents