NOT IN doesn't use index?

Поиск
Список
Период
Сортировка
От Becky Neville
Тема NOT IN doesn't use index?
Дата
Msg-id Pine.LNX.4.44.0305030153230.2047-100000@termite.zoo.cs.yale.edu
обсуждение исходный текст
Ответы Re: NOT IN doesn't use index?  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Antoine
Дата:
Сообщение: looking for large dataset
Следующее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Looking for a cheap upgrade (RAID)