We pop open SSMS to look at what statistics drove an execution plan’s estimates. First, we use a query to find which statistics focus on which columns, and then bust out DBCC SHOW_STATISTICS to understand statistics contents.

Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.