Post reply

Architecture of dbcc dbreindex and indexdefrag

  • March 30, 2010 at 10:38 am

    #139058

    Hi Experts

    Can you let me know the underlying architecture of "dbcc dbreindex" and dbcc indexdefrag". I need the details to understand how the above maintenance queries can boost the performance. Checked BOL, but not satisfied.

    Thanks.

  • March 30, 2010 at 12:20 pm

    #1142550

    Can you let me know the underlying architecture of "dbcc dbreindex" and dbcc indexdefrag". I need the details to understand how the above maintenance queries can boost the performance. Checked BOL, but not satisfied.

    Both DBCC DBREINDEX and INDEXDEFRAG are on the Sql Server Deprecation List.

    I suggest you read up on the REBUILD and REORGANIZE options of the ALTER INDEX Statement.

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

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