SQL Server Performance

SQL Server 2000 - Reorganize same as Rebuild?

Discussion in 'Performance Tuning for DBAs' started by ZLA, Jun 23, 2008.

  1. ZLA New Member

    Under SQL Server 2000 Enterprise Manager's Database Maintenance Plan, is the option to "Reorganize data and index pages" the same as executing the DBCC DBREINDEX command?
    Thanks in advance.
  2. Luis Martin Moderator

    Similar but not the same.
    DBCC DBREINDEX allow you to work with individuals tables and indexes. Not all the database.
    Searching in our forum you will find some scripts to reindex only when is neccesary.
  3. alent1234 New Member

    a reorganize doesn't update statistics and you will need to run that
    a dbreindex drops and recreates and index and the statistics are rebuilt as well

Share This Page