- Prerequisites
- Teradata Database Prerequisites for Analyze Jobs
You must enable Teradata Database query logging with the STATSUSAGE option (XMLPLAN is optional) before selecting either of the evaluate stats options on the Functions tab.
-
From the Jobs tab, do one of the following:
- Click
next to an analyze job and click Edit. - Click an analyze job and click .
- Click
-
Click the Functions tab and select one or more of the following options to be performed when this job is run:
Option Description Evaluate stat usage and staleness and find missing stats to collect Select to have Teradata Database evaluate statistics usage and staleness and find missing statistics to collect so they can be displayed in the portlet. The following selections are optional. - Select Require review before applying recommendations if you want to manually approve or reject recommendations.
- Select Edit Settings to use DBQL or rule-based analysis options to determine statistics usage and staleness, and find new collection opportunities, and then click OK.
Evaluate stats to determine if they should be collected or deactivated Select to have Teradata Database evaluate statistics to determine if they should be collected or deactivated. The following selections are optional. - Select Require review before applying recommendations if you want to manually approve or reject recommendations.
- Enter a number and specify a frequency if you want to recommend statistics be deactivated when they have been inactive for the specified amount of time.
Automate existing stats Select to automate existing statistics. The following selections are optional. - Select Require review before applying recommendations if you want to manually approve or reject recommendations.
- Select Limit to stats to enable the following options:
- Select Initially collected within the last to limit to statistics that were initially collected within the specified days, weeks, or months.
- Select That are actually used to limit to statistics that are actually used.
- Click Save.
-
After the job is run, review the results in the analyze job report.
- If you selected Evaluate stat usage and staleness and find missing stats to collect , review the results in the Missing , Usage , and Stale tabs.
- If you selected Evaluate stats to determine if they should be collected or deactivated , review the results in the Deactivate and Reactivate tabs.
- If you selected Automate existing stats , review the results in the Automate tab.