Post reply

update statistics

  • January 7, 2008 at 2:46 am

    #119522

    Hi

    How I can view the statstics of coulmns in a table

    Binu

  • January 7, 2008 at 4:11 am

    #765275

    SELECT OBJECT_NAME(object_id), name FROM sys.stats

    will show you all the statistics that exist in the DB

    DBCC SHOW_STATISTICS ('Table name','Statistics Name')

    will give you the breakdown of the stats.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 8, 2008 at 12:50 pm

    #765880

    From object explorer, click the tablename --> statistics, it shows all the statistics (index and _WA_).

    Right click each statistics, it shows details about this statistics.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply