Change index on rc_namespace, rc_title to rc_namespace, rc_title, rc_timestamp
[lhc/web/wiklou.git] / maintenance / oracle / archives / patch-recentchanges-nttindex.sql
1 define mw_prefix='{$wgDBprefix}';
2
3 DROP INDEX IF EXISTS &mw_prefix.recentchanges_i02;
4 CREATE INDEX &mw_prefix.recentchanges_i09 ON &mw_prefix.recentchanges (rc_namespace, rc_title, rc_timestamp);