Should secondary indexes be defragmented?

• DarylAndDaryl

  Default port

  Points: 1491

  More actions

  November 4, 2004 at 6:56 am

  #84088

  We are using SQL Server 2000.  It is my understanding that when defragmenting indexes one should only defrag the clustered indexes (DBCC INDEXDEFRAG).  Is this true?  Please explain.

  Seems like I was informed that defragmenting secondary indexes could degrade performance.

  Thank you.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 4, 2004 at 7:35 am

  #528911

  See if this will help you:

  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]