Re: split rows
Thank you,
But I have still a question: how can you explain that an optimize table on a innodb table is much slower than on a myisam table. No dml operation were done on the table in between the different optimize command.
Optimize should do something only if the following tasks are necessary:
- Repair the table if it has deleted or split rows
- Stort the index pages if not sorted
- Update the statistics
Cheers
Dominique
Subject
Written By
Posted
Re: split rows
October 28, 2004 09:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.