maintenance/archives/patch-rc_user_text-index.sql

   1 -- Add an index to recentchanges on rc_user_text
   2 --
   3 -- Added 2006-11-08
   4 --
   5
   6      ALTER TABLE /*$wgDBprefix*/recentchanges
   7 ADD INDEX rc_user_text(rc_user_text, rc_timestamp);