[Bug 5659] New: Unneeded index on bayes_mysql.sql example

[bu...@bugzilla.spamassassin.org]

http://issues.apache.org/SpamAssassin/show_bug.cgi?id=5659

           Summary: Unneeded index on bayes_mysql.sql example
           Product: Spamassassin
           Version: 3.2.3
          Platform: Other
        OS/Version: other
            Status: NEW
          Severity: normal
          Priority: P3
         Component: Documentation
        AssignedTo: dev@spamassassin.apache.org
        ReportedBy: hege@hege.li


Isn't bayes_token_idx1 unneeded, since (id, token) is already indexed? All the 
clauses that I found define ID=? AND TOKEN=? ...

CREATE TABLE bayes_token (
  id int(11) NOT NULL default '0',
  token char(5) NOT NULL default '',
  spam_count int(11) NOT NULL default '0',
  ham_count int(11) NOT NULL default '0',
  atime int(11) NOT NULL default '0',
  PRIMARY KEY  (id, token),
  INDEX bayes_token_idx1 (token),
  INDEX bayes_token_idx2 (id, atime)
) TYPE=MyISAM;



------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

[Bug 5659] Unneeded index on bayes_mysql.sql example

[bu...@bugzilla.spamassassin.org]

http://issues.apache.org/SpamAssassin/show_bug.cgi?id=5659





------- Additional Comments From parkerm@pobox.com  2007-11-23 11:03 -------
I think this is ok.  I can't remember why I added that index but can no longer
think of a reason that it is needed.



------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.