Collect Column Statistics | Teradata Studio - Collecting Column Statistics - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
  1. In the Navigator, double-click Databases.
  2. In the Object List Viewer:
    1. Find the database containing the tables for which you want to collect summary statistics.
    2. Select one or more tables, right-click on a selected table, and select Statistics > Collect > Collect Column Level.
  3. In the Collect Column Statistics form's Columns tab:
    1. 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.
    2. 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.
  4. Click Commit.