SQL Server Performance Forum – Threads Archive
How to find out index stats
What is the command for displaying index stats (distribution, cardinality, etc). I stumbled across this once but I can’t remember what it is, and now a developer is asking me for it. It isn’t sp_helpstats, I think it might be a dbcc command … can anyone help? Tom PullenDBA, Oxfam GB
Sorry.. found it.. ignore that. dbcc show_statistics(), and it is in BOL, apologies for the premature bleating. Tom Pullen
DBA, Oxfam GB
]]>