Page History

...

You can select whether you want SQL defrag manager Defrag Manager to automatically defragment qualifying indexes or to add them to the To Do list. These responses define what SQL defrag manager Defrag Manager does when it identifies a fragmented index during an automated, scheduled analysis. For example, if you select Yes, Automatically Defrag, when SQL defrag manager IDERA performs a scheduled analysis activity, SQL defrag manager Defrag Manager attempt to defragment each index it finds that is not compliant with policy using the selected reorganize or rebuild method. If you select No, Add To Do item, when SQL defrag manager Defrag Manager performs a scheduled analysis activity, SQL defrag manager Defrag Manager creates a To Do item on the To Do view of the SQL defrag manager Defrag Manager Console for each index it finds that is not compliant with policy.

Available options for updating the statistics

The SQL defrag manager SQL Defrag Manager Response tab provides three options for updating your statistics. Before Analysis Renewal updates the statistics for each object covered by this policy each time an analysis is performed. If a reorganization or rebuild is necessary, use Before Optimization to update the statistics before the reorganization or rebuild occurs so the query optimizer has the most current information for building the execution plan for the operation. Never prevents any statistics updates regardless of what other activities occurred.

...