summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-revision-user-page-index.sql
blob: a4554c8f3366c94b7e358b009c8d48bb61faa308 (plain)
1
2
3
4
-- New index on revision table to allow searches for all edits by a given user
-- to a given page. Added 2007-08-28

CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision  (rev_page,rev_user,rev_timestamp);