Only one of the Selected Operations populates Index Analysis Grid and Histogram

Just updated to the latest version of SQL Sentry Plan Explorer and pasted a query into the Command Text window and clicked Get Actual Plan. When I went to the Index Analysis tab there were several Clustered Index Seek and Clustered Index Scan operations shown in the Selected Operation dropdown, however only one of them (Node 24) populates the grid and histogram. Choosing any other operation blanks out the grid and histogram.

tmpB566.pesession (29.9 kB)
avatar image By phaje 1 asked Feb 16, 2017 at 03:23 AM
more ▼
(comments are locked)
avatar image phaje Feb 16, 2017 at 04:57 AM

Okay, just noticed that underneath the dropdown there is a label that is almost the same as the text in the dropdown except instead of having the Node number in brackets at the end it has the number of Indexes. Node 24 says one index and all the rest say zero. (The others are all relating to the subscriber-end of a replicated database and the default for replication is not to replicate non-clustered indexes.)

I guess there is a bit of a perception issue here - in SQL Server Management Studio if I expand out the Tables' Indexes branches it shows the Primary Key, e.g. PK_xyz (Clustered), but SQL Sentry Plan Explorer doesn't seem to "count" that one. Is it not a "real" index?

avatar image Aaron Bertrand ♦ Feb 22, 2017 at 08:09 PM

Actively investigating... can you verify what version of Plan Explorer you are using (Help > About)? This has to do with cross-database queries, and there is an active work item around this.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!


Follow this question



asked: Feb 16, 2017 at 03:23 AM

Seen: 75 times

Last Updated: Feb 22, 2017 at 08:41 PM