Post reply

Statistics

  • June 9, 2010 at 11:18 pm

    #222003

    Hi All..

    I ran the query optimizer for a few larger sql statements. It recommended 3 indexes and about 12 Statistics. What are statistics? What is the cost in terms of performance if I implement the 12 statistics? Can anyone point to a few threads/topics that might discuss this more?

    Thanks,

    Mike

  • June 9, 2010 at 11:31 pm

    #1178443

    http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/

    Don't trust DTA. Test, test, test that those stats are actually useful, that they really do help query performance. I'll be honest, it's unlikely that you'll need all 12, if you need any of them at all.

    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

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

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