Results 1 to 2 of 2

Thread: Index rebuild

  1. 09-21-2009, 07:25 AM #1
    bhosalenarayan
    bhosalenarayan is offline Registered User
    Join Date
    Aug 2009
    Posts
    23

    Index rebuild

    Hi

    i am new to sql server 2005.

    I have a question regarding index rebuild.

    After rebuilding the index using dbcc dbreindex, how do i know that indexes are actually been rebuild.

    Do i need to keep track of some parameters before and after rebuilding the indexes??

    Thanks!!!
    Reply With Quote Reply With Quote
  2. 09-21-2009, 08:00 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Since reindex updates stats, you can check with 'dbcc show_statistics'.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules