Is it a good idea to re-index during week-ends as routine maintenance?

[mb22]

I have a 250meg database with about 10 tables and say 15 - 20 indexes ..... will it be smart to DROP and CREATE the indexes over the week-end when we are off on a regular maintenance routine? Or do i have to wait for a problem before re-indexing if necessary?

 

[mrdenny]

You can reindex when ever you wish. There is no reason to wait until there is a problem. I wouldn't drop and recreate the indexes however, unless you are trying to fix a specific problem. Look up "DBCC DBREINDEX" in BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)