15.00 - Changing a Column Data Type and Statistics - 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)

Changing a Column Data Type and Statistics

If you change a column data type using an ALTER TABLE request, all the statistics on a base table that reference the column are no longer used. Recollecting the statistics on the modified column makes them usable again.