Re: Table doubled in size due to index, way to remove this duplicate data?

[DBA Lead]

I'd also like to see the output of commands that Rick asked for but an fyi, lookups through indexes e.g. BTree are much faster than sequential lookup. In sequential lookups MySQL will roughly take O(n) time (n = no. of rows) where as in case of BTree indexes it'll be roughly O(log n) and indexes will generally be smaller so less disk I/O if there are duplicates in columns or their prefixes.

What storage engine are you using? looks like its Innodb??

--------------------------------------------------------------------
Geeks Worldwide -- http://www.geeksww.com/keywords/tutorials/mysql/



Edited 1 time(s). Last edit at 09/07/2010 08:12PM by DBA Lead.