when to reorganize indexes?

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  January 20, 2005 at 3:39 pm

  #165752

  HI. Can someone tell me how I would go about determining if indexes need to be reorganized? or modified?  Or should reorganization happen on a regular basis?    

   

  Juanita

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 20, 2005 at 3:42 pm

  #538415

  See, if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

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

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  January 20, 2005 at 3:45 pm

  #538416

  HI..

  Thank you so much! I'm going to read this.

  Juanita