The following requests sample statistics on the o_orderkey with user-specified sample percentage. Statistics are collected by reading 10% of the table rows:
COLLECT STATISTICS
USING SAMPLE 10 PERCENT
COLUMN o_orderkey
ON orders;