Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Check Abstract Plan Compatibility

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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating