Hello,

I have a table that seems WAY larger then it should and I'm not sure why. Here is my table layout:

table data,
id (int) PRIMARY KEY
fc_id (int) FOREIGN KEY
topic_id (int) FOREIGN KEY
xref_id (int) FOREIGN KEY
time_id (int) FOREIGN KEY
data (float)

All of the foreign keys are indexed and I have 242559 rows and the space usage is:

Data 13,840 KB
Index 22,592 KB
Total 36,432 KB

If I add up the field sizes and multiple that by rows its about half the size its reports for Data. If anyone can help explain the size of my table I would greatly appreciate it.

Could you give use your index definition ?