Postgres Pro
Downloads
Home   >   mailing lists

Re: HELP WITH A QUERY - Mailing list pgsql-novice

From Mladen Gogala
Subject Re: HELP WITH A QUERY
Date
Msg-id 4CEE75E1.5060001@vmsinfo.com
Whole thread Raw
In response to Re: HELP WITH A QUERY  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-novice
Tree view 
On 11/24/2010 08:35 PM, Jasen Betts wrote:
> all examples untested
>
> eg "NOT IN":
A word of caution: according to my experience, "NOT IN" exhibits much
stronger inclination to produce sequential scan plans than "NOT EXISTS".

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: Postgresql on windows / solid state
Next
From: Stuart Kendrick
Date:
Subject: log statements span multiple lines