Re: NOT IN doesn't use index?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: NOT IN doesn't use index?
Date: 2003-05-03 14:52:12
Message-ID: 20030503145212.GB16290@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Becky Neville 2003-05-03 15:13:17 Re: looking for large dataset
Previous Message Christopher Kings-Lynne 2003-05-03 10:04:22 Re: looking for large dataset