Tuesday, September 7, 2010

How do we list all the statistics for particular table?

USE URDATABASE;
GO
EXEC sp_helpstats 'YOUR_Table_Name'
GO
Posted by at

1 comment:

  1. SQLCode4uDecember 2, 2011 at 9:37 AM

    EXEC sp_updatestats
    is used for updating statistices on Data Base

    ReplyDelete

Subscribe to: Post Comments (Atom)