"alter table mytable order by my_column" is too slowly, why? Please help me.

Thu, 23 Aug 2001 13:43:12 -0700 

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

Reply via email to