des.browning (10/1/2012)
This debate ran in Oracle a few years ago and the same conclusions were reached as seems to be the case in Sql Server - except in a very few clearly defined cases they are a waste of time and can actually make things worse. Great generator of overtime,though.
Seriously? You think index and stats maintenance is a waste of time?
--Jeff Moden
Change is inevitable... Change for the better is not.