> Hello!
>
> I vaguely remember that someone said somewhere that
> EXISTS runs faster than IN:
>
> SELECT * FROM table1 where field1 EXISTS (SELECT
> field4 FROM table2)
Move field1 into the subquery and join it to table2. See the FAQ for an
example.
--
Bruce Momjian
Hello!
I vaguely remember that someone said somewhere that
EXISTS runs faster than IN:
SELECT * FROM table1 where field1 EXISTS (SELECT
field4 FROM table2)
However, all I got from version 7.1.3 is:
ERROR: parser: parse error at or near "exists"
While below works:
SELECT * FROM table1 where
