Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Abstract Plan ID Functions

The following are the functions that are performed on abstract plan IDs.

To use these functions

Right-click the plan ID in the left pane and select the function.

Item

Description

Drop

Drops the selected plan.

Copy

Copies selected plan to another group

Edit

Brings up the Edit Plan window so you can modify the abstract plan.

Find Abstract Plan with Text

Searches for a keyword in the SQL text and abstract plan.

Find Abstract Plan with ID

Searches for a specific plan ID

To use the Abstract Plans for specific users,you enable the use of the Abstract Plan for a specific group on a session level. Therefore, if you have saved Abstract plans in a specific group and you want to use them, you need to set Adaptive Server to use the Abstract Plans in that group. In your application you need to add the following commands:

Note: If the abstract plan is used by many users, you must have already imported the Abstract Plan for each user.

Viewing the text of the SQL statement

When you are viewing the Plan ID, you can view the Definition, the SQL Text, or the Abstract Plan Text by select the corresponding tab. When you are viewing SQL Text, you can format the text by selecting the Format SQL checkbox or the Word Wrap checkbox.

 

Related Topics

Abstract Plan Compatibility with Original SQL

Abstract Plan Manager Window

Open the Abstract Plan Manager

Abstract Plan Manager Overview

Export a Group to a Table

Import an Abstract Plan for each User

Use Saved Abstract Plans

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating