MySQL Forums
Forum List  »  Optimizer & Parser

Re: Simple Query - but explain worries me
Posted by: Vangelis Katsikaros
Date: November 01, 2005 03:05AM

Hi
just an thought, as the SQL optimizer is heavy voodoo stuff (and what I thing might simply not apply)

How about if the a.race_id > 300000 are fewer comparing a) to the a.race_id < 400000 and b) to b.race_id (with value >300000).
Then it would make sense to check the big table first (knowing that from statistics)

Options: ReplyQuote


Subject
Views
Written By
Posted
2945
November 01, 2005 01:26AM
2045
November 01, 2005 02:48AM
Re: Simple Query - but explain worries me
2030
November 01, 2005 03:05AM
1923
November 01, 2005 05:13AM
1946
November 01, 2005 07:37AM
2013
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.