DBREINDEX everything?

• gfahrlander

  SSCommitted

  Points: 1888

  More actions

  July 8, 2003 at 11:38 am

  #64645

  Will running dbcc dbreindex without database.owner.table cause reindexing of all indexes in database?

• brendt hess

  Hall of Fame

  Points: 3256

  More actions

  July 8, 2003 at 12:05 pm

  #464564

  No it will not. You need a script for this. Fortunately, there is one here on this site. See:

  http://www.sqlservercentral.com/scripts/contributions/139.asp

• ckempste

  SSCoach

  Points: 17983

  More actions

  July 8, 2003 at 7:28 pm

  #464606

  It will reindex the table and all its indexes, nothing else.

  Chris Kempster

  http://www.chriskempster.com

  Author of "SQL Server 2k for the Oracle DBA"

  
  Chris Kempster
  www.chriskempster.com
  Author of "SQL Server Backup, Recovery & Troubleshooting"
  Author of "SQL Server 2k for the Oracle DBA"