----- Original Message ----- From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:24 AM Subject: Re: Alter table
> Hi. > > Please start a new thread next time, instead of replying to a > completely unrelated topic. Thank you. > > It sounds as if you want > > ALTER TABLE your_table ADD INDEX( message_id ) > > It is probably enough to only index some part of that field and > save a lot of space: > > ALTER TABLE your_table ADD INDEX( message_id(15) ) Thank you!! The new index caused the search on message_id to be about hundred times as fast! :) Yay! :) - 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