Re: Strategies for dealing with (NOT EQUAL) conditions and indexes

From: Dom Brooks <dombrooks@xxxxxxxxxxx>
To: "mwf@xxxxxxxx" <mwf@xxxxxxxx>
Date: Thu, 17 Nov 2011 17:20:33 +0000

For more info on this behaviour see:
http://richardfoote.wordpress.com/2008/08/13/indexes-and-not-equal-not-now-john/

One alternative if absolutely necessary might be an FBI using CASE for example 
to turn inequality predicate into equality.

Cheers,
Dominic

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- RE: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Taylor, Chris David

References:
- Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Taylor, Chris David
- RE: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Stephens, Chris
- RE: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Taylor, Chris David
- Re: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Taral Desai
- Re: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Sidney Chen
- RE: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Taylor, Chris David
- RE: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Taylor, Chris David
- RE: Strategies for dealing with (NOT EQUAL) conditions and indexes
  - From: Mark W. Farnham

Re: Strategies for dealing with (NOT EQUAL) conditions and indexes

Other related posts: