1 files changed, 19 insertions, 0 deletions
diff --git a/maintenance/archives/patch-backlinkindexes.sql b/maintenance/archives/patch-backlinkindexes.sql
new file mode 100644
index 00000000..5facd9ea
--- /dev/null
+++ b/maintenance/archives/patch-backlinkindexes.sql
@@ -0,0 +1,19 @@
+-- 
+-- patch-backlinkindexes.sql
+-- 
+-- Per bug 6440 / http://bugzilla.wikimedia.org/show_bug.cgi?id=6440
+--
+-- Improve performance of the "what links here"-type queries
+-- 
+
+ALTER TABLE /*$wgDBprefix*/pagelinks
+   DROP INDEX pl_namespace,
+   ADD INDEX pl_namespace(pl_namespace, pl_title, pl_from);
+
+ALTER TABLE /*$wgDBprefix*/templatelinks
+   DROP INDEX tl_namespace,
+   ADD INDEX tl_namespace(tl_namespace, tl_title, tl_from);
+   
+ALTER TABLE /*$wgDBprefix*/imagelinks
+   DROP INDEX il_to,
+   ADD INDEX il_to(il_to, il_from);