Hi!

There is actually a built in SharePoint timer job that rebuilds indexes...if SP2 it rebuilds all indexes once every day.

Take a look at:

http://mysharepointofview.com/2010/02/database-statistics-timer-job-for-good-and-for-bad/

Regards,

Andreas