MySQL Forums
Forum List  »  Optimizer & Parser

Re: Simple Query - but explain worries me
Posted by: Jake Day
Date: November 01, 2005 02:48AM

Been looking further into this, and i'm starting to suspect a minor bug in the "optimizing" package.

Within version 5.0

if i remove

a.race_id > 300000

and add in

a.race_id < 400000

instead, the explain shows it going to the smaller table first. But as soon as i add in the > sign, the "optimizer" wants it to go to the bigger table first.

Maybe this is a recognised difference between DB2 and MySQL, but i can't see any benefit to going to a larger table before a smaller table?

Cheers

Jake Day

Options: ReplyQuote


Subject
Views
Written By
Posted
2964
November 01, 2005 01:26AM
Re: Simple Query - but explain worries me
2054
November 01, 2005 02:48AM
1931
November 01, 2005 05:13AM
1962
November 01, 2005 07:37AM
2026
November 01, 2005 08:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.