maintenance/archives/patch-rc-newindex.sql


1
2
3
4
5
6
7
8
9

--
-- patch-rc-newindex.sql
-- Adds an index to recentchanges to optimize Special:Newpages
-- 2004-01-25
--

ALTER TABLE /*$wgDBprefix*/recentchanges
	ADD INDEX new_name_timestamp(rc_new,rc_namespace,rc_timestamp);