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

   1 -- Adding index to sort by uploader
   2 ALTER TABLE /*$wgDBprefix*/filearchive
   3   ADD INDEX fa_user_timestamp (fa_user_text,fa_timestamp),
   4   -- Remove useless, incomplete index
   5   DROP INDEX fa_deleted_user;