MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Issues with Sub-selects and performance on Win 2003
3768
Adam Reynolds
November 05, 2004 07:01AM
Re: Issues with Sub-selects and performance on Win 2003
2470
A. Weh
November 06, 2004 03:23PM
Re: Issues with Sub-selects and performance on Win 2003
2408
Adam Reynolds
November 11, 2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003
2457
KimSeong Loh
November 11, 2004 07:11PM
Re: Issues with Sub-selects and performance on Win 2003
2420
A. Weh
November 12, 2004 05:49AM


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.