| Index: trunk/phase3/maintenance/indexes.sql |
| — | — | @@ -17,7 +17,8 @@ |
| 18 | 18 | ADD INDEX (cur_random), |
| 19 | 19 | ADD INDEX name_title_timestamp (cur_namespace,cur_title,inverse_timestamp), |
| 20 | 20 | ADD INDEX user_timestamp (cur_user,inverse_timestamp), |
| 21 | | - ADD INDEX usertext_timestamp (cur_user_text,inverse_timestamp); |
| | 21 | + ADD INDEX usertext_timestamp (cur_user_text,inverse_timestamp), |
| | 22 | + ADD INDEX namespace_redirect_timestamp(cur_namespace,cur_is_redirect,cur_timestamp); |
| 22 | 23 | |
| 23 | 24 | ALTER TABLE old |
| 24 | 25 | ADD INDEX (old_namespace,old_title(20)), |