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 (39.9 kB)

By phaje 1 asked Feb 16 at 03:23 AM

(comments are locked)

phaje Feb 16 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?

Aaron Bertrand ♦ Feb 22 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.

0 answers:

Be the first one to answer this question

ask a question

Where to?

Follow this question

Topics:

query plan x580
plan explorer upload x396
query-plan x23
index analysis x4
blank x1

asked: Feb 16 at 03:23 AM

Seen: 33 times

Last Updated: Feb 22 at 08:41 PM

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

Where to?

Follow this question

Related Questions