- In the Navigator, double-click Databases.
-
In the Object List Viewer:
- Find the database containing the tables for which you want to collect summary statistics.
- Select one or more tables, right-click on a selected table, and select .
-
In the Collect Column Statistics form's Columns tab:
-
Select the check boxes next to the columns on which you want to collect statistics.
Tip: To combine column information, select the appropriate check boxes and click Multi Column to create a row containing the selected columns.
- Use the Options tab to specify options like Sampling, Threshold, Max Intervals, and Max Value Length. For more USING options, see Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 .
-
Select the check boxes next to the columns on which you want to collect statistics.
- Click Commit.