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
Select the Scan SQL tab in the main window.
Create a scan job using the Add Scanner Jobs wizard.
Select a group in the Scanner node in the Task pane.
Select the scan job that you want to create a report for in the Job List pane.
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.
Select the checkboxes for the criteria you want to include in the report.
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:
To generate a group summary 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
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center