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.
| Approach | Description |
|---|---|
| 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. |
Prior to implementing a statistics collection approach, you must do the following:
- 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.