SQL Optimizer for SAP ASE 3.9 - Installation Guide

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.

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 Manager Overview

Abstract Plan Group

Why Save the Abstract Plan?

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