maintenance/archives/patch-categorylinksindex.sql

   1 --
   2 -- patch-categorylinksindex.sql
   3 --
   4 -- Per task T12280 / https://phabricator.wikimedia.org/T12280
   5 --
   6 -- Improve enum continuation performance of the what pages belong to a category query
   7 --
   8
   9 ALTER TABLE /*$wgDBprefix*/categorylinks
  10    DROP INDEX cl_sortkey,
  11    ADD INDEX cl_sortkey(cl_to, cl_sortkey, cl_from);