17.05 - Example: HELP STATISTICS on Multiple Individual Columns - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Assume that you have collected the following statistics on an orders table.

     COLLECT STATISTICS COLUMN o_orderdatetime, COLUMN o_orderkey
     ON orders;

The following request displays summary statistics for the orders table. The statistics include the table cardinality, indicated by the report row with the column name *.

     HELP STATISTICS orders;
     *** Help information returned. 3 rows.
     *** Total elapsed time was 1 second.
Date     Time     Unique Values        Column Names
-------- -------- -------------------- ---------------------------------
10/08/16 18:14:36                  100 *
10/08/16 18:10:48                  100 o_orderdatetime
10/08/16 18:05:44                  100 o_orderkey