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


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


  • 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