The Collect List enables you to preview and customize the statistics that a job collects. You can select whether to automatically generate a collect list or use an existing list, and you can prioritize the objects in the list.
- From the Jobs tab, do one of the following:
- Click next to a collect job and click Edit.
- Click a collect job and then click .
- Click the Collect List tab and select one of the following:
Option Description Automatically generate the collect list - Select if you want COLLECT STATISTICS statements to be automatically ordered according to system-determined and user-specified importance.
This option is recommended.
- Select Preview list to generate a collect list.
Use the list below for the next collect only - Select if you want to customize the order of COLLECT STATISTICS statements the next time the job is run.
This option automatically switches to a system-generated collect list after the job runs once. Use this option when you need to temporarily adjust collection priority to favor statistics that need immediate attention.
- Select Regenerate list to clear the current collect list and regenerate a new list.
- Click Continue.
Use the list below for all collections - Select if you want to customize the order of COLLECT STATISTICS statements every time the job is run in the future.
- Select Regenerate list to clear the current collect list and regenerate a new list.
- Click Continue.
Choosing this option prevents changes made from the Scope tab and in the Edit Collect Settings dialog box from taking effect, because the COLLECT STATISTICS statement has already been generated.
- Select if you want COLLECT STATISTICS statements to be automatically ordered according to system-determined and user-specified importance.
- After the collect list is generated, click Close.