MySQL Forums
Forum List  »  MyISAM

Re: Rebuilding Index
Posted by: Rick James
Date: December 20, 2012 02:48PM

You are talking about MyISAM only, correct?

When a table is first created, there are no statistics are available.
As you add data, you may get skewed statistics.
But, while the table is small, performance will be fine, even when it fails to use the "right" index.
Later, one OPTIMIZE may be needed.
Rarely do you need a second OPTIMIZE.

Since your situation does not seem to fit the above pattern, please provide your SHOW CREATE TABLE, SHOW TABLE STATUS, EXPLAIN SELECT.

Options: ReplyQuote

Written By
December 11, 2012 10:26PM
Re: Rebuilding Index
December 20, 2012 02:48PM

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.