Horton

RE: SQL 'in' vs join.

Andrew Snow <andrew@modulus.org>

View thread
From: "Andrew Snow" <andrew@modulus.org>
To: "mlw" <markw@mohawksoft.com>
Cc: <pgsql-hackers@postgresql.org>
Date: 2000-11-30T15:05:01Z
Lists: pgsql-hackers 
> Now, given the two components, each with very low costs, it chooses to
> do a sequential scan on the table. I don't get it. 


Read the FAQ?

http://www.postgresql.org/docs/faq-english.html#4.23
"4.23) Why are my subqueries using IN so slow?")


- Andrew