[Gllug] Size of MySQL indexes

[Dylan]

Hi All,

I'm building a MySQL database at the moment. It contains a table with 13 
VARCHAR(255) fields and an ID field of type INT which is the primary 
key. The data in the table totals 1,114KB, but I notice the index is 
over 21,000KB. Since the index only contains references to an INT 
field, why is it so bg?

Cheers
Dylan
-- 
"The man who strikes first admits that his ideas have given out."
                                                (Chinese Proverb)
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug