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.
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.
Abstract Plan Compatibility with Original SQL
Open the Abstract Plan Manager
Abstract Plan Manager Overview
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
