• You could also play with the thresholds - I also use Ola's defrag scripts but set them to take it easy on re-organize and just go for full rebuild when needed.

    Rebuilding idxs does not hit log growth like reorganizing does.

    As Gail said try adjusting the fill factors on the more volatile idxs, so these operations will be happening less often.

    I've found useful to have a job running at night that captures the fragmentation details of all important idxs, saving them to a table. You can they query the table to see the fragmentation trends day by day. An index that fragments by 30% during a week might need a fill factor of 80 (example!) while one that increases by 5% might be fine with fill factor of 95. Nothing beats measuring and adjusting for your own workload!

    Cheers,

    JohnA

    MCM: SQL2008