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.
The SQL Comparer window is divided into 4 sections: SQL text, query plan, statistics, and abstract plan.
A tab showing a list of SQL statements, the selected tab will be the source of comparison.
By default, the Show SQL text checkbox is selected to display the comparisons between two SQL texts.
You can display the query plans and the abstract plans by selecting the Show SQL Information checkbox which opens the SQL Information pane.
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.
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.
After optimization and when the SQL Optimizer window is active, click . 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.
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 .
To display the comparison
Click .
© ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center