Re: Sequencial scan instead of using index issue again

"Harry Hehl" <Harry.Hehl@diskstream.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