When you automate statistics, they are approved for collection by collect jobs. You can automate existing statistics using an analyze job or you can manually automate statistics as described below.
-
From the Statistics tab, do any of the following:
Scope Description System To automate all statistics within a Teradata Database system: - From the Statistics by Database view, click .
Database To automate all statistics within a single database, do one of the following: - From the Statistics by Object view, click .
- From the Statistics by Database view, click next to the database name and click Automate.
To automate all statistics within multiple databases:- From the Statistics by Database view, click the Table Actions menu and click Automate.
-
Do one of the following:
- Select the check box in the column heading to select all databases.
- Select the check boxes for specific databases.
Object To automate all statistics for a single object, do one of the following: - From the Statistics view, click .
- From the Statistics by Object view, click next to the database name and click Automate.
To automate all statistics for multiple objects:- From the Statistics by Object view, click the Table Actions menu and click Automate.
-
Do one of the following:
- Select the check box in the column heading to select all objects.
- Select the check boxes for specific objects.
Statistic To automate a single statistic, do one of the following: - From the Statistics view, click next to the database name and click Automate.
- From the Statistic Details view, click .
To automate multiple statistics for the same object:- From the Statistics view, click the Table Actions menu and click Automate.
-
Do one of the following:
- Select the check box in the column heading to select all statistics.
- Select the check boxes for specific statistics.