For T89630, some indexes were reordered to make queries more efficient. But the index changes do not seem to have actually been deployed everywhere, for example the old index ordering is still present on db1070 dewiki.pagelinks and db1089 enwiki.pagelinks.
See https://gerrit.wikimedia.org/r/#/c/190774/ for the specific changes involved.