SSMS Statistics Property Window Display Data Differently Than Index Property Window - by Shaun5Stu

Status : 

 


1
0
Sign in
to vote
ID 2960308 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 7/21/2016 1:09:52 PM
Access Restriction Public

Description

In SSMS, when you double-click an index or right-click an index and choose Properties, the Index Properties page, General tab, shows the columns in the index in 
the order they exist in the index. If you do the same to view the Properties page on a statistic, the columns are listed in the order they exist in the table, not 
the order they are in in the statistic.
 To see the order they are in in the statistic, you need to go to the Details tab and look at the density vector. It would be helpful if these two screens showed
 columns in the same 
manner - in the order they exist in the object. See my blog post at http://shaunjstuart.com/archive/2016/07/viewing-statistics-in-ssms/ for info and screenshots.
Sign in to post a comment.