Chat now with support
Chat with Support

Please note, you may experience access issues between 6am - 7am Eastern time on Saturday, May 28 2022 due to planned maintenance

SQL Optimizer for SAP ASE 3.8 - Release Notes

Right Pane for Scenarios

In the Configuration Analyzer window, when a specific Scenario is selected in the left pane, the detailed information about the Scenario displays in the button pages in the right pane. The buttons for displaying specific information are found at the top of this pane.

Properties button

Displays general information about the SQL statement and the database settings at the time of the analysis.

Prognosis button

Displays 3 panes in the right section of the window.

Charts and Summary tabs [Top right pane]

The Chart tab displays five charts of the comparison information for the query plans from before the analysis and during the analysis.

The Summary tab displays summarized statistics for the Scenario,

SQL Classification and Plan Change Comparisons [Middle right pane]

A grid displays the information about each query plan from before the analysis and during the analysis in a comparison format.

SQL Text and SQL Information tabs [Bottom right pane]

The SQL statement that is highlight in the middle right pane is the one that displays in this pane.

The SQL Text tab displays the text of the SQL statement.

The SQL Information tab displays two SQL Information panes, one for the SQL information before the analysis and one for the SQL Information with the parameter changes.

Configuration Parameters button

Displays the database parameter changes used in this analysis displaying the parameter name, the value during the analysis and the old value for the parameters that were changed.

Apply/Undo Changes button

Displays the scripts for changing the configuration parameter on Adaptive Server. Click Executeimage\B_Execute.gif located at the right of the Configuration Analyzer window to run the script.

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating