Specify preferences for displaying Adaptive Server Enterprise execution plans in the Query Plan preference page, on the tab for your version.
To set Adaptive Server Enterprise Query Plan preferences:
Select Window|Preferences from the main menu bar.
The Preferences dialog box appears.
Expand Sybase, Inc in the left pane.
Select Database Development|Query Plan.
Select a plan display orientation:
Vertical orientation displays top to bottom
Horizontal orientationdisplays left to right (default)
Select the action taken on an error during SQL Execution Plan explanation.
Always—Always continues execution when an error occurs.
Never—Always stops execution when an error occurs.
Prompt—Interrupts execution on each error, displaying a dialog to resume execution.
Click the Adaptive Server Enterprise_12.5.x or Adaptive Server Enterprise_15.x tab and select options.
Choose whether to show the query plan in the Execution Plan view while executing SQL statements, for text plans only. For graphic plans, the query must execute to show the plan.
With this option checked you see actual statistics as the query executes.
Whether you select this option or not, you can get an execution plan from the SQL Editor with estimated statistics.
Select a Plan option:
Adaptive Server Enterprise Query Plan Options
| Field | Description |
|---|---|
Graphics Plan | Displays execution plan in graphic format, like Interactive SQL. Default for Adaptive Server Enterprise 15.x. Not available for Adaptive Server Enterprise 12.5.x. |
Text Plan | Displays execution plan in text format, like showplan. Available for Adaptive Server Enterprise 12.5.x and 15.x. |
Setting Query Plan Preferences
See Query Processor in the Adaptive Server Enterprise collection under Sybase WorkSpace Server Administration to understand Adaptive Server Enterprise query optimization and query plans.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com