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;
The following SHOW STATISTICS request does not specify the VALUES option, so it reports only the SQL text for the COLLECT STATISTICS requests listed above, grouping them 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;