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
Referenced Tables View
Breakpoints View
SQL File Editor Outline View
Variables View
Execution Plans
Related tasks
Generating an Execution Plan
Related reference
Database Debug Views
SQL Anywhere Trigger Rows View
Execution Plan View Options Preferences
ASE Execution Plan View Options
ASA Execution Plan View Options
Sybase IQ Execution Plan View Options


Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com