Collecting Summary Statistics - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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 Summary. The message Statistics are collected successfully appears.
  3. To view the statistics:
    1. Right-click a table you selected and select Open Table.
    2. Click the Statistics tab in the Table form. Summary statistics can also be collected using the following query:
      SELECT * from DBC.StatsV WHERE databasename IN (<<dbname>>) AND tablename IN (<<tablename>>);