The Query Details view provides various views with detailed information on each query. The Query Details view is comprised of the following tabs:

• Plan Diagram
• Plan XML
• SQL Text
• Query Columns

Plan Diagram

The Plan Diagram is a visual representation of the query execution plan (actual or estimated) available in XML format in SQL Server. The Plan Diagram displays a view of the tree of operations that make up a query. This tree shows individual operation nodes, pertaining graphical execution plan icon, along with basic information such as operator name and operation percentage of total cost. Click image to view full size.

In the Plan Diagram view you can perform the following actions:

• Select individual operators and view the set of properties for each operator.
• Increase the size of the image (Zoom in).
• Reduce the image size (Zoom out).
  
• Select a size for the view so that fits the current view size (Zoom to fit).
• Export image of Plan Diagram.

Plan XML

The Plan XML tab of the Query Details window displays the actual XML of the query execution plan. It has a syntax-highlighting (color-coded) XML viewer. Click image to view full size.

In the Plan XML view you can perform the following actions:

• Export and save XML file for review in other application such as SSMS or email query execution plan to other DBAs.

SQL Text

The SQL Text tab of the Query Details window shows the underlying SQL Text for the query execution plan. 

In the SQL Text view you can perform the following actions:

• Export and save SQL text for review.
• Access the Plan Diagram, Plan XML, and Query Columns tabs.
  

Query Columns

The Query Columns tab of the Query Details window shows all the referenced columns for the query execution plan. 

In the Query Columns view you can perform the following actions:

• Export and save information to a text file.