Statistics

• Praveen Kumar Pasula

  SSC-Addicted

  Points: 421

  More actions

  November 17, 2004 at 5:50 am

  #87055

  What are statistics? Why do we need them? When do we need to update the statistics ?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 17, 2004 at 6:00 am

  #530468

  That's a very broad question. You might want to read it up in BOL first or here

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;195565

  and then come back with more specific questions.

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]