Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

SQL Comparer Overview

After optimization, the SQL Comparer window provides a way for you to easily compare two SQL statements, query plans, statistics, and abstract plan between the original SQL and optimized alternative SQL statements.

 

Related Topics

SQL Comparer Window

The SQL Comparer window is divided into 4 sections: SQL text, query plan, statistics, and abstract plan.

Source of Comparison

A tab showing a list of SQL statements, the selected tab will be the source of comparison.

Show SQL text checkbox

By default, the Show SQL text checkbox is selected to display the comparisons between two SQL texts.

Show SQL Information checkbox

You can display the query plans and the abstract plans by selecting the Show SQL Information checkbox which opens the SQL Information pane.

Show statistics checkbox

Displays the run time information for the original SQL statement and the selected alternative. The statistics are displayed for both the First Record and All Records if you have retrieved both times.

Compare both sides checkbox

Specify whether to highlight the differences in both SQL statements by selecting the Compare both sides checkbox.

Note: You can control the color of the highlighting in the Preferences window under the Syntax Highlight on the Editor tab.

 

Related Topics

Open SQL Comparer Window

After optimization and when the SQL Optimizer window is active, click image\B_SQLComparer.gif. By default, the original SQL statement is selected as the source of comparison and the differences are highlighted in blue (default) on the right or bottom pane of the window.

Note: To use the SQL Comparer, you must have at least one alternative SQL statement from the optimization process.

 

Related Topics

Start and Stop Comparison

When SQL Comparer is launched, it automatically highlights the differences between the two SQL statements in SQL text panes. Click the Compare both sides checkbox to see the differences highlighted in both SQL text panes. If you want to remove the highlighting of the SQL text, click image\B_StopCompare.gif.

To display the comparison

Click image\B_Compare.gif.

 

Related Topics

Related Documents