Home Forums SQL Server 2005 Administering Managing Indexes in a Database RE: Managing Indexes in a Database
Steve Jones - SSC Editor
SSC Guru
Points: 734314
More actions
December 1, 2007 at 11:54 am
#756248
You can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.
Other than that, SQL Server maintains the indexes fairly well.