15.00 - Changing a Column Data Type and Statistics - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

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.