maintenance/archives/patch-archive-user-index.sql

   1 -- Adds a user,timestamp index to the archive table
   2 -- Used for browsing deleted contributions and renames
   3 ALTER TABLE /*$wgDBprefix*/archive
   4         ADD INDEX usertext_timestamp ( ar_user_text , ar_timestamp );