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? :( Thanks, - Mark --------------------------------------------------------------------- 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
