The long-awaited sequel to AO3-5495.
Sometimes, a database admin has to look up comments by email for the Support committee. Comments aren't currently indexed on email. Doing so would make this a bit faster.
Because comments is a hefty table, the migration should use pt-online-schema-change in staging/production (see a recent example).
To test, run the migration on staging and make sure it's successful.