MySQL Forums
Forum List  »  Optimizer & Parser

not optimizing the table after index is created
Posted by: ragen sol
Date: October 15, 2011 04:04AM

I have created a single index on two columns.

After that I ran the Optimize table command. Optimization of the table is not successful and it suggests to analyze. the following message came

note : Table does not support optimize, doing recreate + analyze instead

status : ok.

I donot understand the note. table type is Innodb.


Options: ReplyQuote

Written By
not optimizing the table after index is created
October 15, 2011 04:04AM

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.