SQL Server Performance

why is DBREINDEX being removed

Discussion in 'SQL Server 2008 General DBA Questions' started by arunjeba@hotmail.com, May 18, 2010.

  1. DBCC DBREINDEX provides an easy way for rebuilding all indexes in a database, and this used to be so useful for performance tuning. But since this is being discontinued from future versions, it has been adviced we should use ALTER INDEX.. REBUILD.
    But we would need to do it one by one for the various tables in the database. Will there be an easy alternative like the old DBCC command?
  2. FrankKalis Moderator

    Welcome to the forum!
    You always had to give at least the table name for DBCC DBREINDEX to rebuild all indexes for that table. Now you just use ALTER INDEX ALL .... So there is not really much of a difference.
  3. satya Moderator

    It has been deprecated, which means the future version of SQL Server may not have this statement.
    All the actions of DBCC DBREINDEX has been given wider range of execution with ALTER INDEX as Frank suggested, for more information on this one refer to books online which ahs plenty of information.

Share This Page