Example: Simple Recollect Statistics Request Using the THRESHOLD Option - Teradata Vantage

The following request collects statistics on the multicolumn set (o_orderstatus, o_orderkey) for the first time. Because of the FOR CURRENT option, the database does not store the THRESHOLD setting.

COLLECT STATISTICS
USING SYSTEM THRESHOLD FOR CURRENT
COLUMN (o_orderstatus, o_orderkey)
ON orders;