On 11/30/10 5:54 PM, Kevin Grittner wrote:
"T.H."<calinet6@xxxxxxxxx> wrote:
Also, are there any better ways you can think of doing such an IN
query, using non-subselect means that might be more efficient?
Have you tried the EXISTS predicate?
-Kevin
Just looking into it now, thanks for the suggestion. Is there a reason
that EXISTS is generally faster than IN for this sort of query?
-Tristan
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
