Re: Why MySQL does not use an index?
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.
Subject
Views
Written By
Posted
2942
January 16, 2012 02:50AM
1341
January 19, 2012 12:25AM
1414
February 10, 2012 01:21AM
Re: Why MySQL does not use an index?
1202
February 10, 2012 09:50AM
1343
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.