Animate Execution Plans
You can animate each step in the execution plan in the order SQL Optimizer executes them.
To animate the execution plan or cancel the animation
| » | Right-click the execution plan and select Animate Plan Steps. |
Compare Plan Cost (Scan SQL)
SQL Optimizer calculates the estimated cost for each SQL statement. Statements with high estimated cost use more system and database resources. SQL Optimizer calculates the cost for each step in the execution plan and totals the cost to provide a resource usage estimate for the entire statement. You can use this estimate to identify the most costly step in the execution plan.
Estimated cost can only be used to compare SQL statements that retrieve the exact same result. Comparisons of estimated cost for statements that do not retrieve the same results are not valid.
Important: The cost only provides an estimate of resource usage to execute a SQL statement. Since statements with higher cost may perform better, you should test generated alternatives to determine the best statements for your database environment.
Send to Optimize SQL
You can optimize SQL statements extracted by SQL Scanner using SQL Optimizer. SQL Optimizer supports single INSERT, UPDATE, SELECT, DELETE, or MERGE SQL statements.
To send a statement to SQL Optimizer
- Select the Scan SQL tab in the main window.
-
Create a scan job using the Add Scanner Jobs wizard. See Scan SQL for more information.
-
Select a group in the Scanner node in the Task pane.
-
Select a scan job from the Group node.
-
Select the SQL statement in the Job List pane.
-
Click
in the SQL Text pane.
Notes:
- If the selected SQL statement uses a temporary table and SQL Scanner finds a CREATE TABLE or SELECT INTO statement, the User-Defined Temp Table window displays automatically. See Use Temporary Tables in Scan SQL for more information.
- If the selected SQL statement is used within a cursor declaration, the Cursor Settings window displays automatically. See Optimize SQL Statements for more information.
- If the selected SQL statement uses a variable, SQL Scanner automatically assigns the CHAR datatype to the variable when it retrieves the execution plan. To assign a different datatype, click
after you send the statement to SQL Optimizer and select the new datatype in the Set Bind Variables window that displays. See Set Bind Variables for more information.
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
- Select the Scan SQL tab in the main window.
- In the Task pane, select the Scanner node.
- In the Group Summary pane, select a group and click
.
- Select the sections you want to include in the report from the Group Summary Report Options dialog.
- Click OK to generate the report.