Home Forums SQL Server 7,2000 T-SQL Indexes RE: Indexes
hoo-t
SSChampion
Points: 12713
More actions
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