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