summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/sqlite/archives/patch-recentchanges-nttindex.sql
blob: 3684066846eeec0dda3e54ed35db3b709e647d60 (plain)
1
2
3
4
5
6
7
8
9
10
--
-- patch-recentchanges-nttindex.sql
--
-- Per task T57377
--
-- Improve performance API queries to ask for a certain pages
--

DROP INDEX IF EXISTS /*i*/rc_namespace_title;
CREATE INDEX IF NOT EXISTS /*i*/rc_namespace_title_timestamp ON /*_*/recentchanges (rc_namespace, rc_title, rc_timestamp);