2 -- patch-backlinkindexes.sql
4 -- Per task T8440 / https://phabricator.wikimedia.org/T8440
6 -- Improve performance of the "what links here"-type queries
9 ALTER TABLE /*$wgDBprefix*/pagelinks
10 DROP INDEX pl_namespace
,
11 ADD INDEX pl_namespace(pl_namespace
, pl_title
, pl_from
);
13 ALTER TABLE /*$wgDBprefix*/templatelinks
14 DROP INDEX tl_namespace
,
15 ADD INDEX tl_namespace(tl_namespace
, tl_title
, tl_from
);
17 ALTER TABLE /*$wgDBprefix*/imagelinks
19 ADD INDEX il_to(il_to
, il_from
);