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
3477
November 01, 2005 01:26AM
2274
November 01, 2005 02:48AM
Re: Simple Query - but explain worries me
2292
November 01, 2005 03:05AM
2153
November 01, 2005 05:13AM
2190
November 01, 2005 07:37AM
2258
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.