Optimizing existing tables by changing data types
Lets say i have a table with 10,000 rows and one of the columns is of type
INT and unsigned. If i alter the column to be of type SMALLINT and
unsigned will it shrink the space the existing data takes on the disk? or
only future inserts?
No comments:
Post a Comment