Tara has posted some very useful database maintainance routines over a past couple of weeks

and she has summarized the whole of them here.