[SQL] optimizing select ... not in (select ...)

) -- Laurent Martelli [EMAIL PROTECTED] http://www.bearteam.org/~laurent/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Re: Donations?

a request on the site, telling how much you are willing to spend to see it developped. Other users can join you so that's more money for the developpers. Developpers can submit proposals. You choose one, commit money on it, the developper does the work, you pay him and everybody's happy

[SQL] Re: optimizing select ... not in (select ...)

>>>>> "Tomas" == Tomas Berndtsson <[EMAIL PROTECTED]> writes: Tomas> Laurent Martelli <[EMAIL PROTECTED]> writes: >> I have this query : >> >> select distinct on (Pictures.PictureID) * from Pictures where >> Picture