At 15:13 +0900 12/26/02, Chung Ha-nyung wrote:
I've heard that I should periodically alter innodb table to MyISAM and back to InnoDB to optimize table structure. I guess only dropping index and recreating it is enough, but should I change table type?
Dropping an index doesn't change a table's type. You can change the type like this:
ALTER TABLE t TYPE = MyISAM; ALTER TABLE t TYPE = InnoDB;
query. -- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.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