SQL Optimizer for SQL Server 10.1 - User Guide

Generate Reports

Generate Scanned Jobs Reports

You can generate a scanned jobs report in SQL Scanner. The scanned jobs report provides information about the SQL statements for a selected scan job that includes:

• Chart for SQL Classification

• SQL conversion

• Temp table dependencies

• SQL position

• SQL Text

• Execution Plan

  Tip: You can display execution plans in text mode, grayscale graphic mode, or full color graphic mode.

• SQL Classification

To generate a scanned jobs report

1. Select the Scan SQL tab in the main window.

2. Create a scan job using the Add Scanner Jobs wizard. See "Scan SQL" in the online help for more information.See Scan SQL for more information.

3. Select a group in the Scanner node in the Task pane.

4. Select the scan job that you want to create a report for in the Job List pane.

5. Click .

   Tip: You can also generate a selected SQL report by selecting a scan job from the Group node of the Task pane and clicking in the SQL List pane.

6. Select the checkboxes for the criteria you want to include in the report.

Generate Group Summary Reports

You can generate a group summary report in SQL Scanner. The group summary report provides information about all the scan jobs for a selected group and includes:

• Job status
• Job type
• SQL classification

To generate a group summary report

1. Select the Scan SQL tab in the main window.
2. In the Task pane, select the Scanner node.
3. In the Group Summary pane, select a group and click .
4. Select the sections you want to include in the report from the Group Summary Report Options dialog.
5. Click OK to generate the report.

Generate Optimize SQL Resolution Report

You can generate a resolution report in SQL Optimizer after you optimize your SQL statement and execute the alternatives. The resolution report includes the following:

• Resolution summary

• Original SQL statement

• Optimization Session Information

• Scenario List

• Comparison Graph

• Best Alternative Scenario

To generate an Optimize SQL resolution report

1. Select the Optimize SQL tab in the main window.

2. Click .

3. 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.