Adaptive Server generates an abstract plan based on the SQL syntax itself. If a SQL statement is transformed to another syntax that the Adaptive Server optimizer cannot transform internally, then the abstract plans are not compatible. Therefore, even though two SQL statements may be semantically equivalent, their abstract plans are not compatible.
For example, take this SQL statement as your original SQL statement:
SELECT A CITY FROM A, B, C
WHERE A.CITY =B.CITY
AND B.CITY=C.CITY
And take this semantically equivalent alternative SQL:
SELECT A.CITY FROM A, B, C
WHERE A.CITY =B.CITY
AND B.CITY=C.CITY
AND A.CITY=C.CITY
The transforms adds the new condition, A.CITY=C.CITY, and if the Adaptive Server optimizer cannot generate A.CITY=C.CITY internally for your original SQL, then an index scan from A.CITY to C.CITY or from C.CITY to A.CITY is not possible for your original SQL. So, the new abstract plan is not compatible for the original SQL.
Also, if an OR condition is transformed to a UNION, the new abstract plan is so different from the original SQL that there is no way for the original SQL to be compatible with the new abstract plan.
Open the Abstract Plan Manager
Import an Abstract Plan for each User
The left pane is a tree structure for the managing of the elements of the abstract plan: Groups, Users, and Plan IDs.
Right-click any element to bring up the right-click menu with the functionality for that element.
The right pane displays the information that corresponds to the group, users, or plan ID that is selected in the left pane.
Abstract Plan Compatibility with Original SQL
Open the Abstract Plan Manager
Import an Abstract Plan for each User
To open the Abstract Plan Manager
Click ..
Abstract Plan Compatibility with Original SQL
Import an Abstract Plan for each User
The following are the functions that are performed on abstract plan groups.
To use these functions
Right-click the group name in the left pane and select one of the following functions.
Item | Description |
Create |
Creates a new abstract plan group |
Drop |
Drops the select abstract plan group. |
Purge |
Deletes all abstract plans in the selected group |
Copy All Plan |
Copies all abstract plans in the selected group to another group. |
Rename |
Renames the abstract plan group. |
Export |
Exports the abstract plan group to a table. |
Import |
Imports an exported table to a database, user and group |
Compares the differences between two groups. |
Abstract Plan Compatibility with Original SQL
Open the Abstract Plan Manager
Abstract Plan Manager Overview
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center