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.
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.