MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
3030
Chris Ricks
February 02, 2012 01:17AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1288
Chris Ricks
February 01, 2012 07:33PM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1308
Chris Ricks
February 02, 2012 03:06AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1197
Øystein Grøvlen
February 02, 2012 03:58AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1258
Chris Ricks
February 02, 2012 04:43AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1193
Rick James
February 03, 2012 11:57PM


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.