We plan to change indexes in 4.2. We would like people to test new indexes
in busy production environments to make sure new set will work better or at
least on the same level.
If you would like to participate then you need to know how to enable log of
slow queries in your DB, list existing indexes, create new indexes and have
time to do this, collect results and write down report.
Best regards, Ruslan.