The following requests system-determined sample statistics on the o_orderdatetime column.
Teradata collects full statistics and remembers the sample option. Teradata considers downgrading the sample percentage after the system captures enough history and the column is identified as eligible for sample statistics:
COLLECT STATISTICS
USING SYSTEM SAMPLE
COLUMN o_orderdatetime
ON orders;