X-Git-Url: https://git.cyclocoop.org/%7B%24admin_url%7Dmembres/modifier.php?a=blobdiff_plain;f=maintenance%2Ftables.sql;h=1da651adaf0d395e8bef7b1c349622f5b1f21c6d;hb=f303a13a72605735b071d07aa56b79c12e614ef5;hp=f601bfcb6b1509bd3a97efe4917d02b7d93023b1;hpb=8d68145a16c3bdf1c42dec80b4294592bfd09af0;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index f601bfcb6b..1da651adaf 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -1464,7 +1464,7 @@ CREATE TABLE /*_*/recentchanges (
 CREATE INDEX /*i*/rc_timestamp ON /*_*/recentchanges (rc_timestamp);
 
 -- Special:Watchlist
-CREATE INDEX /*i*/rc_namespace_title ON /*_*/recentchanges (rc_namespace, rc_title);
+CREATE INDEX /*i*/rc_namespace_title_timestamp ON /*_*/recentchanges (rc_namespace, rc_title, rc_timestamp);
 
 -- Special:Recentchangeslinked when finding changes in pages linked from a page
 CREATE INDEX /*i*/rc_cur_id ON /*_*/recentchanges (rc_cur_id);