Example: Collecting Statistics on Multiple Columns with an Expression - Teradata Vantage

This example includes an expression and collects statistics on multiple columns.

COLLECT STATISTICS USING SYSTEM SAMPLE
COLUMN (EXTRACT(MONTH FROM o_orderdate), o_totalprice)
AS stats_month_price
ON orders;