maintenance/archives/patch-archive-utindex.sql

   1 -- Add an index to archive on ar_user_text, ar_timestamp
   2 --
   3 -- Added 2006-11-27
   4 --
   5
   6      ALTER TABLE /*$wgDBprefix*/archive
   7 ADD INDEX usertext_timestamp (ar_user_text, ar_timestamp);