https://bugzilla.wikimedia.org/show_bug.cgi?id=9900

--- Comment #4 from MZMcBride <[email protected]> 2012-04-26 02:54:03 UTC ---
Looking at tables.sql on Gerrit
(<https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/core.git;a=blob;f=maintenance/tables.sql;h=a848bf5eb469ce63b2693b4a392241c5eab76dd1;hb=HEAD>),
we can see the pagelinks, templatelinks, categorylinks, imagelinks, langlinks,
and iwlinks all have a unique index on them. externallinks, however, has the
following indices:

---
CREATE INDEX /*i*/el_from ON /*_*/externallinks (el_from, el_to(40));
CREATE INDEX /*i*/el_to ON /*_*/externallinks (el_to(60), el_from);
CREATE INDEX /*i*/el_index ON /*_*/externallinks (el_index(60));
---

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to