[Gllug] Size of MySQL indexes

[Martin A. Brooks]

Dylan wrote:
> over 21,000KB. Since the index only contains references to an INT 
> field, why is it so bg?

Well, assuming MySQL works like other databases then I'm not really 
surprised.

Approximately speaking, a SQL index does three things, it contains at 
least three pointers per indexed field, roughly:

* where _this_ field is
* where the next field is in relation
* where the last field is in relation

For complex indexing, i.e. free text, the indexes can be _huge_.


-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug