I execute this SQL with mysql 3.23.39 (all platform, Windows98, Windows2000 and Redhat Linux 7.1), but it's very very slowly. alter table mytable order by my_column; mytable has 3,000,000 rows, my_column is define as char(15). But when mytable has 1,000,000 rows, it's very fast, about 1.5 minute. =================================================== http://sms.163.com 网易短信 发自内心 http://love.163.com 牵伊之手共享人生欢娱!NEW! http://alumni.163.com 碧云天,黄叶地,校园情怀依如昔 --------------------------------------------------------------------- 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