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