Post reply

Indexes

  • June 23, 2004 at 8:58 am

    #108611

    I would like to know what are the index exists on which table in my entire database.And also i want to rebuild some of them.

    How can i do these two things.

    Thanks.

  • June 23, 2004 at 3:16 pm

    #511671

    dbcc showcontig will show you all the indexes, and even which ones should be rebuilt.  Based on the results of showcontig, you can then use dbcc dbreindex or dbcc indexdefrag to rebuild the indexes. 

    Steve

  • June 24, 2004 at 5:18 am

    #511742

    Or if your database is not too large simply use the Maint. wizard and rebuild all indexes. I do this on most of the dbs. under 2 gig a couple of times a year.

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

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