Post reply

SQL Maint Utility

  • April 17, 2006 at 12:01 pm

    #152913

    Does the -RebldIdx parameter kick off a DBCC DBREINDEX, a DBCC INDEXDEFRAG, or something else entirely?

  • April 17, 2006 at 12:22 pm

    #632816

    OK, so I found information on the net that says SQL Maint uses the standard DBCC REINDEX statement.  So, I lookup DBCC REINDEX in BOL (which it DOES list) but it has information instead on DBCC DBREINDEX.

    At this point, I'll assume that SQL Maint runs DBCC DBREINDEX and that BOL has an entry for "REINDEX" to preemptively catch misspellings.

    If anyone knows something different, please let me know. RH

  • April 18, 2006 at 12:53 pm

    #632947

    You are correct, sqlmaint uses DBCC DBREINDEX.

    I believe it was DBCC REINDEX up to version 7.0, then renamed DBREINDEX in SQL 2000.  In SQL 2005 it's ALTER INDEX (although DBCC DBREINDEX is still recognized).

Viewing 3 posts - 1 through 2 (of 2 total)

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