Working with Plan Diagrams

Query Profiler allows you to examine plans of different queries in a single view. For this, hold the CTRL key and select several plan diagrams in the query profiling tree.

Plans Comparison

You can set a number of plans that you want to compare with the most recent result. For this, click Compare Selected Results and then select a required number.

The following screen shot demonstrates that the Compare last two results option is selected. In this case, when you modify a query and then click Get-New-Results the Get New Results button, the most recent result will be automatically compared with Plan #2.

Compare last two results

Plan #1 does not participate in comparison.

Automatic Plan Comparison

To zoom in and out a pan diagram, right click the plan diagram and then click Zoom.