indexes ?

• bang.prashant

  Ten Centuries

  Points: 1100

  More actions

  October 7, 2008 at 9:16 am

  #123866

  can you tell me which method is better and why ? and when to implement?

  1. Drop and recreate Indexes

  2. DBCC DBREINDEX

  3.DBCC INDEXDEFRAG

  4. Rebuild indexes

  5. Reorgnize indexes

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  October 7, 2008 at 9:29 am

  #881755

  This is a cross post from this question http://www.sqlservercentral.com/Forums/Topic581916-65-1.aspx.

  Please do not post the same question in multiple forums.

  To help us help you read this[/url]For better help with performance problems please read this[/url]