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

[Laurent Martelli]

I have this query :

select distinct on (Pictures.PictureID) * from Pictures where Pictures.PictureID not 
in (select distinct PictureID from Keywords);

and I find it a bit slow. Does anybody have suggestions to run this
faster ? (I have indexes on PictureID on both Pictures and Keywords) 

-- 
Laurent Martelli
[EMAIL PROTECTED]              http://www.bearteam.org/~laurent/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]