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.
   

   ZLA, Jun 23, 2008

   #2
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.
   

   Luis Martin, Jun 23, 2008

   #3
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
   

   alent1234, Jun 24, 2008

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in