- 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.