Post reply

Reindex sequence

  • February 13, 2003 at 7:08 am

    #357707

    I have to recreate some indexes that show high fragmentation, and i was thinking if this is a correct scenario (and sequence):

    - Execute DBCC DBREINDEX over this indexes

    - Run UPDATE STATISTICS over this indexes

    - DBCC UPDATEUSAGE(DB) over the entire db

    I hear you...

  • February 13, 2003 at 9:21 am

    #448879

    you could try first DBCC INDEXDEFRAG to avoid locking.

  • February 13, 2003 at 10:32 am

    #448903

    Sorry, i forgot to mention that i'm working over SQL7, i think that this command works only in 2000

  • February 17, 2003 at 6:08 am

    #449092

    Still waiting...anybody can help me?

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

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