Recent Changes No Index
The query on Special:Recentchanges does not hit any index on the revision table. While the query sorts a large number of results anyway, adding an index on forumid could significantly reduce query time when there are other namespaces with large numbers of articles.
Fixed for the next build.