Working with query plan diagrams

Query Profiler allows you to examine execution plans of different queries in a single view. The execution plan visually shows the estimated execution plan of a query and helps optimize SQL queries. To analyze multiple execution plans, hold the CTRL key and select several plan diagrams in the query profiling tree.

In the plan diagram compare plans of several queries

In the Query Profiler panel, you can set a number of plans to compare with the most recent result. For this, click Compare Selected Results and select a required option, for example, Compare last two results. Then, modify a query and click Click Get New Results in Query Profiler Get New Results. The most recent result will be automatically compared with Plan #2. The comparison will not include Plan #1.

Compare last two results

On the Plan Diagram, you can use the shortcut menu options to perform the following operations:

  • Order the cost by CPU, I/O, Operator, and Operator excluding the color highlight.
  • Arrange line width by rows or data size
  • Zoom in and out a pan diagram
  • Export to the image
  • Print the diagram
  • View the properties

Manage the diagram using the shortcut menu options

In addition, hover over the icon of the diagram element to view the information.

View some information about the element on the diagram

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Query Builder for SQL Server.
Request a demo

Request a demo

If you consider employing the Query Builder for your business, request a demo to see it in action.
Ready to start using dbForge Query Builder for SQL Server?
Download a free 30-day trial