The Compare tab in the SQL Optimizer window enables you easily to compare SQL text, access plans, and statistics between two alternatives or between an alternative and the original SQL.
The Compare tab consists of two major panes—Source of Comparison and Compare With. Each pane shows information for one alternative. Differences in syntax and access plans are highlighted in either pane.
Use the pane-control buttons to reorganize the panes:
To display panes vertically
Click .
To display panes horizontally
Click .
To display or remove SQL Text panes
Click .
To display or remove Access Plan panes
Click .
To display or remove Statistics panes
Click .
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center