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

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

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;