Redundant indexes
Issue reported by Gordan Bobic on SE: https://civicrm.stackexchange.com/questions/39409/redundant-indexes
It looks like there are several redundant or partly redundant indexes that civicrm creates on the database. Some of this may be storage engine specific (e.g. InnoDB), but some isn't. (see SE issue for more information)