A while back I had asked if anyone knew of the disadvantages of adding extra indexes to MySQL, and how best to optimize the indexing.
I found a great summary article on this exact topic. It cleared up some of the mystery for me anyway.
mike
General developer forum
MySQL and indexing
This discussion has been locked so you can no longer reply to it.