On Tue, 2003-03-18 at 21:38, [EMAIL PROTECTED] wrote:
>  Description:
> 
>      Hello Peter,
> 
>      Have you explained to Heikki this problem?
>      Have you fixed it?
> 
>      Please, tell me about it.
> 

Dear Rafarife,

This problem is qualified as wrong optimizer plan selection.
Happily you can select proper plan by using FORCE INDEX() clause.

We will improve optimizer to handle this case, but I can't promise you 
how soon this would happen - it is very tricky task as you need to make
sure your changes do not worsen behavior in other cases.

Also I would recommend you to posting your message to most appropriate
mailing list instead of both. Many users are subscribed to both mailing
list and they will get your message twice. 


-- 
 MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /   Peter Zaitsev <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
 /_/  /_/\_, /___/\___\_\___/   Moscow, Russia
        <___/   www.mysql.com   


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to