Check Abstract Plan Compatibility
View Abstract Plan Matrix Window
To check the compatibility between the original SQL statement and the abstract plan from the optimized SQL statements
Click 
The Abstract Plan Matrix window is mainly divided into a top and bottom section. The top section shows a matrix of the SQL (source, Alt1, Alt2 …) and the abstract plan (AP0, AP1, AP2 …). The bottom section has 3 panes which show the SQL text, abstract plan, XML plan, query plan, and trace on details. To display the third pane with the XML plan query plan, and trace on information (the right-most pane), select the Show SQL Information based on abstract plan checkbox.
Note: The trace on information is only displayed if the dbcc traceon option is selected on the Database Setting tab in the Preferences window. The XML Plan is only displayed if you are connected to Adaptive Server 15.0 or later.
The Abstract Plan Matrix provides the following functions:
|
Function |
Description |
| Check Selected | Check the compatibility of the selected abstract plan and SQL. |
|
Check All |
Check the compatibility of all the abstract plans and SQL statements. |
|
Check Column |
Check the compatibility of the selected SQL statement with all the abstract plans. |
|
Check Row |
Check the compatibility of the selected abstract plan with all the SQL statements. |