From: Peter Brawley
Date: March 4 2010 6:58pm
Subject: Re: Has Query optimizer improved in 5.4/5.5?
List-Archive: http://lists.mysql.com/mysql/220856
Message-Id: <4B9002EB.3080804@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------040608070204060203040105"

--------------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--