Generate Optimize SQL Resolution Report
You can generate a resolution report in SQL Optimizer after you optimize your SQL statement and test run the alternatives. The resolution report includes the following:
-
Resolution summary
-
Original SQL statement
-
Optimization Session Information
-
Scenario List
-
Comparison Graph
-
Best Alternative Scenario
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To generate an Optimize SQL resolution report
- Select the SQL Details tab in the main window.
-
Click
.
-
Click
in the Report window to customize the information displayed in the resolution report.
Tip: You can display execution plans in text mode, grayscale graphic mode, or full color graphic mode.