Chat now with support
Chat with Support

SQL Optimizer for SQL Server 10.1.2 - User Guide

Welcome to SQL Optimizer Optimize SQL
Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL Plan Control Use Temporary Tables
Optimize Indexes Find SQL Scan SQL Manage Plan Guides Configure Options Tutorials About Us

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.


Related Topics

Copy Execution Plans

Fill Missing Execution Plans


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.


Related Topics  

Compare Plan Cost (Scan SQL)


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

  1. Select the Scan SQL tab in the main window.
  2. Create a scan job using the Add Scanner Jobs wizard. See Scan SQL for more information.

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

  4. Select a scan job from the Group node.

  5. Select the SQL statement in the Job List pane.

  6. Click in the SQL Text pane.


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



Related Topics

About Scanning SQL

Optimize SQL Statements

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.


Related Topics  

Manage Groups

Generate Scanned Jobs Reports

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating