MySQL Forums
Forum List  »  Optimizer & Parser

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
Posted by: Chris Ricks
Date: February 01, 2012 07:33PM

Some further investigation seems to indicate that only the first column in the index is used for query plan evaluation, for example:

* Supplying a query that constrains on both client_id and settlement AND providing an index hint to use IX_settlement_client results in 5606808 rows being examined according to EXPLAIN
* Supplying the same query without a query hint AND without a client_id constraint results in 5606808 rows being examined according to EXPLAIN

Has anyone else observed this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1193
February 01, 2012 07:33PM


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.