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