You can use a submit-based approach, analyze-based approach, or a combination of both approaches, to automate statistics collection using the Stats Manager portlet.
|Submit-Based||Use this approach to:
|Analyze-Based||Use this approach to:
|Combination||Use a combination of both submit-based and analyze-based approaches to ensure data is collected on stale statistics on a timely basis.|
- Use the automate options to approve the statistics you want to automate.
- Create collect jobs to ensure that all automated statistics are associated with a collect job.
All automated statistics are associated with a collect job when 100% of automated stats have collect jobs displays on the Statistics by Database view on the Statistics tab.