The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Update: The first difference isn't quite as significant as first thought; it's all about the Hide SQL/Show SQL button :)

The Plan Viewer displays similar plans differently depending on how the plans were requested.

The following images were captured from two plans for more-or-less the same query. The "meat" of the plans are essentially identical; this posting is about GUI differences.

Here are the differences...

  • Image 1 doesn't show the top "SQL" pane by default like image 2 (the initial Hide SQL/Show SQL button settings are different)

  • Image 1 incorrectly shows "Statistics level: Optimizer estimates only"... this is a flaw in all plans produced by GRAPHICAL_PLAN().

  • Image 1 does show percentages in the diagram; image 2 does not.

The first image is of a plan captured via the following call to GRAPHICAL_PLAN()...

SELECT TOP 1 rroad_sample_set.sample_set_number
  FROM rroad_sample_set
       INNER JOIN rroad_group_2_property_pivot
                ON rroad_group_2_property_pivot.sample_set_number = rroad_sample_set.sample_set_number
 WHERE rroad_group_2_property_pivot.connection_id_string = @connection_id_string
   AND rroad_sample_set.sample_started_at                <= DATEADD ( MONTH, -1, @sample_finished_at )
 ORDER BY rroad_sample_set.sample_started_at DESC;
      2, -- Detailed statistics including node statistics
      'READ-ONLY' );

image 01 plan captured via GRAPHICAL_PLAN.png

The second image is of a plan for a query run in ISQL.

image 02 plan captured via ISQL.png

asked 16 Jan '14, 11:21

Breck%20Carter's gravatar image

Breck Carter
accept rate: 21%

edited 23 Jan '14, 04:01

Volker%20Barth's gravatar image

Volker Barth

For the second one I would like to have the percentages too!

(23 Jan '14, 03:45) Martin
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 16 Jan '14, 11:21

question was seen: 1,265 times

last updated: 23 Jan '14, 04:01