MySQL Forums
Forum List  »  Optimizer & Parser

Re: Issues with Sub-selects and performance on Win 2003
Posted by: Adam Reynolds
Date: November 11, 2004 09:05AM

Ok here's one:


select p.draftid, p.seat, count(*) as picksout from picklists p where p.pick is null and p.draftid in (select draftid from draftplayers where email = '#attributes.email#') and p.draftid in (select draftid from drafts where endtime is null) group by draftid,seat

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Issues with Sub-selects and performance on Win 2003
2146
November 11, 2004 09:05AM


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.