Creating a Text Execution Plan

A text execution plan displays plan information in text format. Text plans are available only for Adaptive Server Enterprise data servers.

Prerequisites 

Before you can create an execution plan, you must connect to a data server.

  1. From the WorkSpace main menu, choose Window > Preferences.
  2. In the Preferences dialog, expand the tree view for Sybase, Inc and Database Development, and highlight Execution Plan View Options to display the execution plan view options in the right panel.
  3. Select the tab for your data server, and choose Text Plan from the Plan options drop-down menu. Click OK to apply the preference setting and close the Preferences dialog.
  4. Obtain your execution plan. The generated plan appears in text format.
Related concepts
Execution Plans
Execution Plan View
Related tasks
Obtaining an Execution Plan
Creating a Graphic Execution Plan
Related reference
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.