Hi, I have a database with 14 million rows which contains 3 indexes. I am trying to drop two of these indexes and create another one. However each operation takes about 12 hours. Is there anyway I can make this a lot faster by changing runtime variables and similar things. Thanks in advance, Richard --------------------------------------------------------------------- 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