Post reply

How long does DBCC REINDEX for a table of size 1GB takes

  • May 12, 2006 at 5:02 am

    #152968

    How long does DBCC REINDEX for a table of size 1GB takes ?

    I just want to do for some tables during the time of release as there will be some down time .

    Does REINDEX effect anything else?

  • May 12, 2006 at 6:26 am

    #637514

    It very much depends on how many indexes are on the taqble, whether they are compound (more than one column) or not, what column data-types are indexed, what your disk subsystem is like, etc.

    DBCC DBREINDEX is an offline process, meaning that the table being reindexed is unavailable to queries until complete.

     

    Check out DBCC DBREINDEX and DBCC INDEXDEFRAG in Books Online.

  • May 12, 2006 at 7:37 am

    #637544

    other than taking the table to offline, does it effect anything else?

  • May 12, 2006 at 10:42 am

    #637632

    Yes, keep an eye on your log file...

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

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