Re: NOT IN doesn't use index?

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