Collecting Statistics on a PERIOD Data Type Column - Teradata Vantage - Analytics Database

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

You can collect statistics on the BEGIN and END bound functions of PERIOD type columns, for example,

COLLECT STATISTICS COLUMN BEGIN(Policy_Duration)
                                AS Stats_BegDuration,
                   COLUMN END(Policy_Duration) AS Stats_EndDuration
ON policy_types;