Rebuild index,Reorganize index or update statistics

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  February 9, 2009 at 8:03 am

  #201048

  Hi experts

  Can you please tell me when and how to use Rebuild index,Reorganize index or update statistics advocatly . And if possible the difference between them.

  Tanx 😀

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  February 9, 2009 at 9:03 am

  #940549

  Hi

  Check out the below article, which will clarify all your questions with examples.

  http://decipherinfosys.wordpress.com/2008/02/07/index-rebuilding-vs-index-reorganizing-in-sql-server-2005/

  Thanks -- Vijaya Kadiyala

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers

  
  

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  February 11, 2009 at 12:26 am

  #941869

  thax

  can you please tell me more on statistics and how to use it for improving performance.

  can u give some real time situations where we use these three to improve performance of the server.

  Tanx 😀

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 11, 2009 at 4:11 am

  #941984

  Eswin (2/11/2009)

  ---

  can you please tell me more on statistics and how to use it for improving performance.

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

  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

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  February 11, 2009 at 7:24 am

  #942124

  Thax

  Tanx 😀