Editing the Collect List - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
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.
  1. 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 Actions > Edit.
  2. Click the Collect List tab and select one of the following:
    Option Description
    Automatically generate the collect list
    1. Select if you want COLLECT STATISTICS statements to be automatically ordered according to system-determined and user-specified importance.

      This option is recommended.

    2. Select Preview list to generate a collect list.
    Use the list below for the next collect only
    1. 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.

    2. Select Regenerate list to clear the current collect list and regenerate a new list.
    3. Click Continue.
    Use the list below for all collections
    1. Select if you want to customize the order of COLLECT STATISTICS statements every time the job is run in the future.
    2. Select Regenerate list to clear the current collect list and regenerate a new list.
    3. 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.

  3. After the collect list is generated, click Close.