"Harry Hehl" <Harry.Hehl@xxxxxxxxxxxxxx> writes: > I am having an issue with a joins. I am using 8.0.3 on FC4 > > Query: select * from ommemberrelation where srcobj='somevalue' and dstobj in > (select objectid from omfilesysentry where name='dir15_file80'); > > PLAN ... > (29 rows) That plan doesn't correspond to the query you posted. Try sending the result of EXPLAIN ANALYZE from the actual query or else posting the actual query you're running. -- greg
