• It depends a little on how much data is building up and if its causing an issue. In a high throughput distribution db you can have the replication cleanup jobs running every few minutes to keep the data levels low (assuming the distribution agent is doing its job).

    With low data levels index fragmentation isn't a problem.