Example: SHOW STATISTICS for COLLECT STATISTICS SQL Text Only - Teradata Vantage

Suppose you have collected the following statistics on table orders.

     COLLECT STATISTICS 
       COLUMN o_orderdatetime ON orders;
     COLLECT STATISTICS 
       USING SAMPLE 
       COLUMN CAST(o_orderdatetime AS DATE) AS orderdate ON orders;
     COLLECT STATISTICS 
       USING SAMPLE 
       COLUMN o_orderpriority ON orders;
     COLLECT STATISTICS 
       USING SAMPLE 10 PERCENT 
       COLUMN o_custkey ON orders;
     COLLECT STATISTICS 
       USING SAMPLE 10 PERCENT 
       COLUMN o_orderkey ON orders;
     COLLECT STATISTICS 
       USING MAXINTERVALS 250 AND MAXVALUELENGTH 15
       COLUMN (o_orderdatetime, o_orderkey) ON orders;
     COLLECT STATISTICS 
       COLUMN o_totalprice ON orders;

Without the VALUES option, the following SHOW STATISTICS request reports only the SQL text for the preceding COLLECT STATISTICS requests, grouped by the USING option used to collect the statistics.

     SHOW STATISTICS ON orders;
     COLLECT STATISTICS 
USING NO SYSTEM SAMPLE
AND SYSTEM MAXINTERVALS 
AND SYSTEM MAXVALUELENGTH
 COLUMN o_orderdatetime,
  COLUMN o_totalprice
ON orders;
     COLLECT STATISTICS 
USING SYSTEM SAMPLE 
AND SYSTEM MAXINTERVALS 
AND SYSTEM MAXVALUELENGTH
 COLUMN CAST(o_orderdatetime AS DATE) AS OrderDate, 
  COLUMN o_orderpriority
ON orders;
     COLLECT STATISTICS 
USING SAMPLE 10 PERCENT 
AND SYSTEM MAXINTERVALS 
AND SYSTEM MAXVALUELENGTH
 COLUMN o_custkey, 
  COLUMN o_orderkey
ON orders;
     COLLECT STATISTICS 
USING NO SYSTEM SAMPLE 
AND MAXINTERVALS 250
AND MAXVALUELENGTH 15
 COLUMN (o_orderdatetime, o_orderkey) 
ON orders;