Page History

...

See About the Current tab on page 40, About the Activity tab on page 49, and About the Objects tab on page 67.

Anchor
HowtheSQLtabisstructured HowtheSQLtabisstructured

How the SQL tab is structured

...

The Plan view is divided into two panes. The Execution Plan tree is displayed in the left pane. The Details area is displayed in the right pane. The information displayed in the Details area is controlled by the information tabs (Highlights, Objects, Statistics, Operations, Properties) located above the Details area.

Anchor
AbouttheExecutionplantree AbouttheExecutionplantree

About the Execution plan tree

The Plan view displays the Execution Plan tree of the specified statement. When you analyze the access plan of a selected statement, you can examine the access path that was chosen by the Adaptive Server Query Optimizer. The Explain result is displayed as an Explain tree. Each branch in the Explain tree represents one operation. Each operation is displayed in the following format:

...

The Highlights tab displays the statement's text.

Anchor
Aboutviewingwhichobjectsarereferencedbytheexecutionplan Aboutviewingwhichobjectsarereferencedbytheexecutionplan

About viewing which objects are referenced by the execution plan

The Objects tab displays three tables (Tables used in the plan, Indexes of table, and Columns of table) that list all referenced objects in the Execution Plan, including their indexes and columns. Statistical details and general details are displayed for each object and its sub-entities.

...

• If the operator is a Table Scan, try creating an index.
• If the operator is of a Join type (such as Nested Loop or Merge), examine a different join method.
• If the operator is a Sort operation, check if the sort is required by the application or can be removed. For example, remove distinct or change the union clause to union all.

See “About About the Execution plan tree” on page 100tree.

Anchor
Locatingreferencedtablesthatposepotentialproblems Locatingreferencedtablesthatposepotentialproblems

Locating referenced tables that pose potential problems

...

1. Launch to the SQL tab with a statement in-context or open the statement you want to analyze in the SQL tab.
2. On the Plan tab, click Objects.
3. Click the Locator icon (to locate and highlight all the operators in the execution plan that access the specified table).
4. Examine the cost of these operators (to locate the problematic operators).
5. Identify the objects that are referenced by the problematic operators and try to tune those objects.

See “About About viewing which objects are referenced by the execution plan” on page 103plan.

Anchor
Examininghowaccesspathchangesaffectstatementperformance Examininghowaccesspathchangesaffectstatementperformance

Examining how access path changes affect statement performance

...