-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Mon, Jan 29, 2001 at 08:23:14AM -0800, Simon Legdon wrote:
> I was once told by an Oracle contractor that Oracle does not optimize NOT IN
> queries well, and that the most efficient way of doing this is to use the NOT
> EXISTS form that I suggested. This advice was for Oracle 7, I admit.
It still holds true for Oracle 8. Oracle will not use an index on an IN clause,
but it will if you use EXISTS and there is a usable index on the columns you're
querying.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBOnWt2gOGqGs0PadnEQI/1QCg2XlHW7PKaMQHzlIyMJetM4fSptEAnRdr
yhGyIj075E7CU+1KB4mSmygj
=y1+O
-----END PGP SIGNATURE-----
