MySQL Forums
Forum List  »  Optimizer & Parser

Re: Different Servers Using Different Index for Same Query on Same Data
Posted by: Rick James
Date: March 31, 2011 11:06PM

In 5.0.82 and 5.1.35, there is

I, too, have encountered the problem. Yes, USE INDEX and FORCE INDEX are often the wrong thing to do, but in this situation, is can be the right thing.

The "statistics" from the Analyze are not saved across a restart.

Options: ReplyQuote

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.