Postgres Pro
Downloads
Home   >   mailing lists

Re: NOT IN doesn't use index? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: NOT IN doesn't use index?
Date
Msg-id 20030503145212.GB16290@libertyrms.info
Whole thread Raw
In response to NOT IN doesn't use index?  (Becky Neville <rebecca.neville@yale.edu>)
List pgsql-performance
Tree view 
On Sat, May 03, 2003 at 01:56:02AM -0400, Becky Neville wrote:
> Does the use of WHERE field  NOT IN ('A','B' etc) prevent the use of an
> index?

That '&c.' is hiding a lot.  Why not post your query and the explain
analyse output?

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: looking for large dataset
Next
From: Becky Neville
Date:
Subject: Re: looking for large dataset