After {T190444} It would be great to apply this change
From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes:
# **ALTERs to run:** <https://gerrit.wikimedia.org/r/c/mediawiki/core/+/450083/2/maintenance/archives/patch-recentchanges-rc_this_oldid-index.sql>
# **Where to run those changes:** all.dblist
# **When to run those changes:** //?//
# **If the schema change is backwards compatible:** Yes.
# **If the schema change has been tested already on some of the test/beta wikis:** Tested in beta cluster
# **if the data should be made available on the labs replicas and/or dumps:** Yes, data in this table is public (unless the wiki is private which we don't replicate at all)
One note: This index might be already existing but under name of tmp_1 or tmp_2 or tmp_3. I don't know how complex renaming an index is but that'd be useful.
Progress:
s1
[] eqiad
[] codfw
s2
[x] eqiad progress T202167#4788212
[x] codfw
s3
[] eqiad progress T202167#4822929
[x] codfw
s4
[x] eqiad progress T202167#4796465
[x] codfw
s5
[x] eqiad progress T202167#4793284
[x] codfw
s6
[x] eqiad progress T202167#4773117
[x] codfw progress T202167#4773117
s7
[x] eqiad progress T202167#4816251
[x] codfw
s8
[x] eqiad progress T202167#4809890
[x] codfw
wikitech
[x] eqiad
[x] codfw