Home > mailing lists

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

From	Becky Neville
Subject	NOT IN doesn't use index?
Date	May 3, 2003 04:56:06
Msg-id	Pine.LNX.4.44.0305030153230.2047-100000@termite.zoo.cs.yale.edu Whole thread Raw
Responses	Re: NOT IN doesn't use index? (Andrew Sullivan <andrew@libertyrms.info>)
List	pgsql-performance

Tree view

I have been looking through the archives but can't find anything on this.

Does the use of WHERE field  NOT IN ('A','B' etc) prevent the use of an
index?
Would changing the query to WHERE field <> 'A' and field <> 'B' etc help?

The query only involves one table, and this is the only field in the where
clause.  Explain plan indicates a Sort and Seq Scan are being done.

THanks

pgsql-performance by date:

From: Antoine
Date: 03 May 2003, 04:51:05
Subject: looking for large dataset

From: "D'Arcy J.M. Cain"
Date: 03 May 2003, 06:57:56
Subject: Re: Looking for a cheap upgrade (RAID)

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

Previous

Next