r66822 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r66821‎ | r66822 | r66823 >
Date:12:31, 24 May 2010
Author:werdna
Status:resolved (Comments)
Tags:
Comment:
Fix index creation
Modified paths:
  • /trunk/phase3/maintenance/tables.sql (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/tables.sql
——@@ -417,7 +417,7 @@
418418
419419 CREATE INDEX /*i*/name_title_timestamp ON /*_*/archive (ar_namespace,ar_title,ar_timestamp);
420420 CREATE INDEX /*i*/ar_usertext_timestamp ON /*_*/archive (ar_user_text,ar_timestamp);
421 -CREATE INDEX /*i*/ar_page_revid ON /*_*/archive (ar_namespace, ar_title, ar_id);
 421+CREATE INDEX /*i*/ar_page_revid ON /*_*/archive (ar_namespace, ar_title, ar_rev_id);
422422
423423
424424 --

Follow-up revisions

RevisionCommit summaryAuthorDate
r79702Per fixme on r66822, change index to CREATE INDEX /*i*/ar_page_revid ON /*_*/...reedy02:15, 6 January 2011
r79746Followup r79702, r66793, r66822...reedy19:27, 6 January 2011

Comments

#Comment by Aaron Schulz (talk | contribs)   13:59, 24 May 2010

Why isn't the index just on ar_rev_id?

#Comment by Werdna (talk | contribs)   01:12, 26 May 2010

Probably could be.

#Comment by 😂 (talk | contribs)   19:35, 23 October 2010

Can someone please take care of this?

Status & tagging log