none
What's the statistics under the table RRS feed

Answers

  • Hi,

    this is what statistics does for you, Read more here

    http://technet.microsoft.com/en-us/library/cc966419.aspx

    SQL Server 2005 statistics features allow you to:

    • implicitly create and update statistics with the default sampling rate (in the SELECT, INSERT, DELETE, and UPDATE commands, use of a column in a query condition such as a WHERE or JOIN clause causes statistics to be created or updated if necessary when automatic statistics creation and update is enabled)

    • manually create and update statistics with any desired sampling rate, and drop statistics (CREATE STATISTICS, UPDATE STATISTICS, DROP STATISTICS, CREATE INDEX, DROP INDEX)

    • manually create statistics in bulk for all columns of all tables in a database (sp_createstats)

    • manually update all existing statistics in the database (sp_updatestats)

    • list statistics objects that exist for a table or database (sp_helpstats, catalog views sys.stats, sys.stats_columns)

    • display descriptive information about statisticsobjects (DBCC SHOW_STATISTICS)

    • enable and disable automatic creation and update of statistics database-wide or for a specific table or statistics object (ALTER DATABASE options AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS, sp_autostats, and the NORECOMPUTE option on CREATE STATISTICS and UPDATE STATISTICS)

    • enable and disable asynchronous automatic update ofstatistics (ALTER DATABASE option AUTO_UPDATE_STATISTICS_ASYNC)

    Regards
    Satheesh

    • Marked as answer by QLoveQ Thursday, June 28, 2012 5:40 AM
    Monday, June 25, 2012 10:34 AM

All replies

  • http://blogs.technet.com/b/rob/archive/2008/05/16/sql-server-statistics.aspx


    Thanks,

    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

    Monday, June 25, 2012 8:11 AM
  • http://technet.microsoft.com/en-us/library/cc966419.aspx

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

    Monday, June 25, 2012 8:15 AM
    Answerer
  • Is there anybody can explain this in Chinese?

    Life is not so easy.......

    Monday, June 25, 2012 8:19 AM
  • Hi,

    this is what statistics does for you, Read more here

    http://technet.microsoft.com/en-us/library/cc966419.aspx

    SQL Server 2005 statistics features allow you to:

    • implicitly create and update statistics with the default sampling rate (in the SELECT, INSERT, DELETE, and UPDATE commands, use of a column in a query condition such as a WHERE or JOIN clause causes statistics to be created or updated if necessary when automatic statistics creation and update is enabled)

    • manually create and update statistics with any desired sampling rate, and drop statistics (CREATE STATISTICS, UPDATE STATISTICS, DROP STATISTICS, CREATE INDEX, DROP INDEX)

    • manually create statistics in bulk for all columns of all tables in a database (sp_createstats)

    • manually update all existing statistics in the database (sp_updatestats)

    • list statistics objects that exist for a table or database (sp_helpstats, catalog views sys.stats, sys.stats_columns)

    • display descriptive information about statisticsobjects (DBCC SHOW_STATISTICS)

    • enable and disable automatic creation and update of statistics database-wide or for a specific table or statistics object (ALTER DATABASE options AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS, sp_autostats, and the NORECOMPUTE option on CREATE STATISTICS and UPDATE STATISTICS)

    • enable and disable asynchronous automatic update ofstatistics (ALTER DATABASE option AUTO_UPDATE_STATISTICS_ASYNC)

    Regards
    Satheesh

    • Marked as answer by QLoveQ Thursday, June 28, 2012 5:40 AM
    Monday, June 25, 2012 10:34 AM
  • This is indeed a big topic and can't be explained in short or simply answered in a forum based environment. Uri and Andrew have already given you some link for yout digest.

    我想这是一个很大的议题。这个议题很难有一个简单的答复,特别是在论坛环境下。Uri (MVP) 和 Andrew 已经给了你连接你可以自己仔细的读一下。

    I will give you another link which is :Statistics used by SQL server 2008 white paper, which I found is a great paper and I learned a lot from this paper as below
    http://msdn.microsoft.com/en-us/library/dd535534(v=sql.100).aspx

    我也给你一个连接:Statistics used by SQL server 2008 白皮书。我自己认为这是很好的一个指导,我自己学了不少。连接如下:

    http://msdn.microsoft.com/en-us/library/dd535534(v=sql.100).aspx


    View Steven Wang's profile on LinkedIn | Blog: MSBICOE.com | MCITP - BI, SQL Developer & DBA

    Hate to mislead others, if I'm wrong slap me. Thanks!


    Monday, June 25, 2012 11:37 AM
  • Thanks all.

    I will check them if I have time.


    Life is not so easy.......

    Thursday, June 28, 2012 5:41 AM