"Harry Hehl" <Harry(dot)Hehl(at)diskstream(dot)com> 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