Only one of the Selected Operations populates Index Analysis Grid and Histogram
2017-02-16 03:23:26
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.
2017-02-22 20:09:00
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.
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?