You can edit collect settings for multiple statistics within a Teradata Database system, multiple statistics within one or more databases, or multiple statistics for one or more objects.
-
From the Statistics tab, do any of the following:
Settings Description System To edit collect settings for multiple statistics within a Teradata Database system: - From the Statistics by Database view, click .
Database To edit collect settings for multiple 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 Edit Collect Settings.
To reset collect settings for multiple statistics within multiple databases:- From the Statistics by Database view, click the Table Actions list and click Edit Collect Settings.
-
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 edit collect settings 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 Edit Collect Settings.
To edit collect settings for multiple statistics for multiple objects:- From the Statistics by Object view, click the Table Actions list and click Edit Collect Settings.
-
Do one of the following:
- Select the check box in the column heading to select all objects.
- Select the check boxes for specific objects.
-
To define the collect settings, do any of the following:
- Select System-defined if you want Teradata Database to decide the settings.
- Select None if you do not want thresholds, a sampling method, or histogram.
- Click OK.