| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -344,6 +344,7 @@ |
| 345 | 345 | CREATE INDEX rc_cur_id ON recentchanges (rc_cur_id); |
| 346 | 346 | CREATE INDEX new_name_timestamp ON recentchanges (rc_new, rc_namespace, rc_timestamp); |
| 347 | 347 | CREATE INDEX rc_ip ON recentchanges (rc_ip); |
| | 348 | +CREATE INDEX rc_patrolling ON recentchanges (rc_this_oldid, rc_last_oldid, rc_patrolled); |
| 348 | 349 | |
| 349 | 350 | |
| 350 | 351 | CREATE TABLE watchlist ( |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -880,7 +880,7 @@ |
| 881 | 881 | INDEX rc_ip (rc_ip), |
| 882 | 882 | INDEX rc_ns_usertext (rc_namespace, rc_user_text), |
| 883 | 883 | INDEX rc_user_text (rc_user_text, rc_timestamp), |
| 884 | | - INDEX `rc_patrolling` ( `rc_this_oldid`, `rc_last_oldid`, `rc_patrolled` ) |
| | 884 | + INDEX rc_patrolling (rc_this_oldid, rc_last_oldid, rc_patrolled) |
| 885 | 885 | |
| 886 | 886 | ) /*$wgDBTableOptions*/; |
| 887 | 887 | |