MySQL Forums
Forum List  »  Optimizer & Parser

Re: Why MySQL does not use an index?
Posted by: irek kordirko
Date: February 10, 2012 09:50AM

Panayotis Matsinopoulos Wrote:
-------------------------------------------------------
> So, the only difference that I see (at first look)
> is that MySQL on PRODUCTION is a little bit older.

I see another subtle difference:
the table on test has 9 records,
but on production has 768,767 rows.
Remember that the optimizer takes into account table and index statistics
(number ow rows in tables/indexes), and basing on these informations
chooses a plan.

Options: ReplyQuote


Subject
Views
Written By
Posted
1055
January 19, 2012 12:25AM
Re: Why MySQL does not use an index?
946
February 10, 2012 09:50AM
1066
February 11, 2012 10: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.