maintenance/archives/patch-categorylinksindex.sql

   1 --
   2 -- patch-categorylinksindex.sql
   3 --
   4 -- Per bug 10280 / http://bugzilla.wikimedia.org/show_bug.cgi?id=10280
   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);