I couldn't find in mysql documentation any information on how much disk
space indexes require. I've just created a table - 8 columns and 11
rows, with 2 indexes on SMALLINT columns - 1 unique and 1 normal. I
filled the table with some data, there is some text as well but not
much. Now PhpMyAdmin reports that the data take up 256 bytes while the
indexes 3,072 bytes. The index file is incredibly large compared to the
amount of data! Will this ratio remain like this when I insert new data
into the table? How much disk space do indexes require?
Received on Mon Jan 05 2004 - 13:36:20 CST
