15.00 - Collecting Statistics on a PERIOD Data Type Column - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Collecting Statistics on a PERIOD Data Type Column

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;