In T383561#10486887, @Jdforrester-WMF wrote:

Next step, for the DBAs:

• The ALTER TABLEs to run:
  • https://gerrit.wikimedia.org/r/c/mediawiki/extensions/WikiLambda/+/1110779/2/sql/mysql/patch-add-zobject-join-type-index.sql
  • https://gerrit.wikimedia.org/r/c/mediawiki/extensions/WikiLambda/+/1110779/2/sql/mysql/patch-add-zobject-labels-priority-index.sql
  • https://gerrit.wikimedia.org/r/c/mediawiki/extensions/WikiLambda/+/1110779/2/sql/mysql/patch-add-zobject-labels-zid-index.sql
• Where to run those changes: wikifunctionswiki
• When to run those changes: Any time
• If the schema change is backwards compatible: Yes
• If the schema change has been tested already: Dev machines only
• If it involves new columns or tables, if the data should be made available on the wiki replicas: N/A
• Is this schema change blocking a feature rollout? Yes, T382140.