From 4b37e34dc6653e8192cfa30895bb8a9d5d09f842 Mon Sep 17 00:00:00 2001 From: Erik Moeller Date: Fri, 23 May 2003 06:20:54 +0000 Subject: [PATCH] new index for oldest_articles --- maintenance/indexes.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/maintenance/indexes.sql b/maintenance/indexes.sql index d8f8d99424..279105c7b9 100644 --- a/maintenance/indexes.sql +++ b/maintenance/indexes.sql @@ -17,7 +17,8 @@ ALTER TABLE cur ADD INDEX (cur_random), ADD INDEX name_title_timestamp (cur_namespace,cur_title,inverse_timestamp), ADD INDEX user_timestamp (cur_user,inverse_timestamp), - ADD INDEX usertext_timestamp (cur_user_text,inverse_timestamp); + ADD INDEX usertext_timestamp (cur_user_text,inverse_timestamp), + ADD INDEX namespace_redirect_timestamp(cur_namespace,cur_is_redirect,cur_timestamp); ALTER TABLE old ADD INDEX (old_namespace,old_title(20)), -- 2.20.1