Rebuild Indexes? 1

[saw15]

Working on a Health Care DB, which gets quite a bit of traffic.

Should we be rebuilding indexes at a regular interval? If so, what would that interval be? Or is rebuilding not necessary?

Help, tips and tricks gladly accepted.

Thanks

 

[Tim1]

Hiya,

I can't see any need to rebuild indexes. If you run an Update Statistics and a DBCC on a regular basis, this should take care of it for you.

HTH

Tim

 

[tlbroadbent]

Yo should rebuild or defrag indexes if they become fragmented. Update stats and DBCC will not do this unless Tim was referring to DBCC DBREINDEX or DBCC INDEXDEFRAG. Use DBCC SHOWCONTIG to determine fragmentation. See the following for more info.

http://www.sql-server-performance.com/rebuilding_indexes.asp

http://www.sql-server-performance.com/dt_dbcc_showcontig.asp

You can download a script from SWYNK.COM to help track table fragmentation.

http://www.swynk.com/sqlscripts/maintenance7.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.