Has Query optimizer improved in 5.4/5.5?

I am using MySQL 5.1.30 (MyISAM) and the query optimizer is quite bad at
choosing the proper index.

I often have to force it to use the correct index for Select statements,
otherwise takes 50x to 100x slower than it should be.
Has the query optiimizer improved any for later MySQL versions?
TIA

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Has Query optimizer improved in 5.4/5.5?

--------------040608070204060203040105
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mike,

> Has the query optiimizer improved any for later MySQL versions?

Have a look at http://dev.mysql.com/tech-resources/articles/mysql-54.html.

Peter Brawley
http://www.artfulsoftware.com

-----

mos wrote:
> I am using MySQL 5.1.30 (MyISAM) and the query optimizer is quite bad
> at choosing the proper index.
>
> I often have to force it to use the correct index for Select
> statements, otherwise takes 50x to 100x slower than it should be.
> Has the query optiimizer improved any for later MySQL versions?
> TIA
>
> Mike
>
>
> ------------------------------------------------------------ ------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.435 / Virus Database: 271.1.1/2721 - Release Date: 03/03/10 19:34:00
>
>

--------------040608070204060203040105--