Reducing an index size
Posted on 2006-05-21
I am restructuring my databse to store data more efficently.
I had a table with a primary index made up of an int and a varchar(30) column. By using lookup tables, I altered the varchar column to a smallint. By my cacluations, the index size should be reduced to about one third of the original, but it only went down to two thrids, when looking at index length in MySQL administrator.
Does this seem right, or is the database allocating chunks of space to the index and not releasing it all? Optimizing the table made no difference.