MySQL Forums
Forum List  »  Optimizer & Parser

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

Hi Jake

Since there are no children without parents I guess you are correct. The best return from the big table would be equal to the retrurn of the small one. A case where all parents above a number ie 300000 each has only one child).

Just for the record, when you do
SELECT * FROM header a WHERE a.race_id > 300000
and then
SELECT * FROM details b WHERE b.race_id > 300000

what results do you get?

Options: ReplyQuote


Subject
Views
Written By
Posted
2963
November 01, 2005 01:26AM
2053
November 01, 2005 02:48AM
1931
November 01, 2005 05:13AM
Re: Simple Query - but explain worries me
2017
November 01, 2005 05:57AM
1962
November 01, 2005 07:37AM
2024
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.