15.10 - Example: Summary Multicolumn Statistics - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Consider the following collect statistics request.

     COLLECT SUMMARY STATISTICS 
       COLUMN CAST(o_orderdatetime AS DATE AT 0) AS OrderDate,
       COLUMN (CAST(o_orderdatetime AS DATE AT 0), o_orderkey) 
               AS OrderDateAndKey
     ON orders;

The following request displays a summary of statistical information for the multicolumn statistics using their names, order_date and order_date_and_key, respectively.

     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                   15 order_date
10/08/16 18:05:44                  100 order_date_and_key