RE: SQL 'in' vs join.

From: "Andrew Snow" <andrew(at)modulus(dot)org>
To: "mlw" <markw(at)mohawksoft(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: SQL 'in' vs join.
Date: 2000-11-30 15:05:01
Message-ID: JEEGIJPOJIGGIIHGKOKOKEJNCFAA.andrew@modulus.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-11-30 15:15:31 Re: compiling pg 7.0.3 on sco 5.0.5
Previous Message Don Baccus 2000-11-30 14:55:21 Re: Please advise features in 7.1 (SUMMARY)