| From: | "Marc Rohloff" <Marc(dot)Rohloff(at)eskom(dot)co(dot)za> |
|---|---|
| To: | <josh(at)agliodbs(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Outer Joins |
| Date: | 2000-11-02 07:11:50 |
| Message-ID: | sa013083.027@eskom.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>> select a.col1, b.col2 from a,b
>> where a.col1 = b.col2
>> or a.col1 not in (select b.col2 from b)
>This would work, but it would be *much* slower than a UNION query. "Not
>In" queries are perhaps the slowest you can run; see the earlier thread
>"Query Problem" for a discussion. UNION queries are, in fact, very fast
>... just awkward to code and manipulate.
Why should this be slower since the UNION Query still has an identical not in clause?
This is far easier (for me) to read.
Marc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerhard Dieringer | 2000-11-02 07:55:53 | Antw: Outer Joins |
| Previous Message | Bruce Momjian | 2000-11-02 03:38:54 | Re: INSERT [IGNORE] INTO TABLE |