* Mark > Can some please help me? > > I created a MySQL table with newsgroup articles in them, and > indexed them on > article_num, > > article_num int unsigned not null primary key > > But now, as I found out that searching on message_id, using a WHERE clause > tends to get very slow. So, I was wondering whether I can change the table > to have message_id be the secondary key. Now it is, > > message_id varchar(255) > > But I would like it to become, > > message_id varchar(255) not null secondary key > > Can I alter the table to this effect, or am I too late? :(
No, it is not too late. :) There is no "secondary key", but an index will do what you want. <URL: http://www.mysql.com/doc/C/R/CREATE_INDEX.html > -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php