Post reply

DBCC DBREINDEX vs Maintenace Plan question

  • March 14, 2003 at 12:12 pm

    #159699

    Does the DBCC DBREINDEX command do the same think as the option in the maintenance plan to Reorganize data and index pages??

    Thanks for your help!

  • March 17, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • March 17, 2003 at 11:44 am

    #451244

    DBCC DBREINDEX is for a single table in any database.

    But where as SQLMAINT.exe is used to indexing the same for all the tables in a given database.

    Regards,

    Murali Daemra.

    .

  • March 17, 2003 at 12:21 pm

    #451252

    I understand DBCC DBREINDEX is for a single table only but what exactly does it do to the table as opposed to the sqlmaint.exe. For instances, does the DBCC DBREINDEX drop and recreate the index and the other doesn't??

    Thanks for the help, Vicki

  • June 19, 2003 at 8:53 am

    #462152

    Read the article 'Inside Sql Server Maintenance Plans'

    at

    http://www.sql-server-performance.com/ak_inside_sql_server_maintenance_plans.asp

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply