Not rebuilding as a blanket criteria is not a good idea. On paper it looks good but the reality, as PAVB pointed out is that heavily updated tables will see indexes grow out of control. I have 3 prod boxes that have this issue and when rebuilding saves 50% of the tablespace, well, it is hard to argue that you should not rebuild cause Tom says so.




Reply With Quote