maintenance/sqlite/archives/patch-recentchanges-nttindex.sql

   1 --
   2 -- patch-recentchanges-nttindex.sql
   3 --
   4 -- Per task T57377
   5 --
   6 -- Improve performance API queries to ask for a certain pages
   7 --
   8
   9 DROP INDEX IF EXISTS /*i*/rc_namespace_title;
  10 CREATE INDEX IF NOT EXISTS /*i*/rc_namespace_title_timestamp ON /*_*/recentchanges (rc_namespace, rc_title, rc_timestamp);