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