This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:
|
1 |
DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName); |
Views – 2195
This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:
|
1 |
DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName); |
Views – 2195