Architecture of dbcc dbreindex and indexdefrag

  • 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.

  • 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