Page History

...

• 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: Updates 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.

...

Select the Use NORECOMPUTE check box, and SQL Server does not maintain the statistics after you perform a manual update. Leave this check box clear and SQL Server maintains statistics after a manual update.

Need more help? Search the IDERA Customer Support Portal

...