Execution Plan View

The Execution Plan view displays execution plans for a specified SQL statement.

Depending on how you have set the preferences for viewing execution plans, the Execution Plan view shows a graphic execution plan or text execution plan with or without optimizer statistics.

Execution plans and corresponding optimizer statistics are shown in separate panes of the Execution Plan view. For a graphic execution plan, optimizer statistics are shown for each node. To see the statistics for a node, select the node in the graphic execution plan pane of the Execution Plan view.

Related concepts
SQL Results View
Referenced Tables View
Breakpoints View
SQL File Editor Outline View
Variables View
Execution Plans
Related tasks
Obtaining an Execution Plan
Creating a Graphic Execution Plan
Creating a Text Execution Plan
Related reference
Database Debug Views
SQL Anywhere Trigger Rows View
Execution Plan View Options
ASE Execution Plan View Options
ASA Execution Plan View Options
Sybase IQ Execution Plan View Options

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.