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

From: Dom Brooks <dombrooks_at_hotmail.com>
Date: Thu, 17 Nov 2011 17:20:33 +0000
Message-ID: <BLU0-SMTP135272EBE4E9D37BD29C265A1C70_at_phx.gbl>

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

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

Received on Thu Nov 17 2011 - 11:20:33 CST

This message: [ Message body ]
Next message: Taylor, Chris David: "RE: Strategies for dealing with (NOT EQUAL) conditions and indexes"
Previous message: Joel.Patterson_at_crowley.com: "RE: Naming standards -- that lead to implicit/explicit constraint and index creation."
In reply to: Mark W. Farnham: "RE: Strategies for dealing with (NOT EQUAL) conditions and indexes"
Next in thread: Taylor, Chris David: "RE: Strategies for dealing with (NOT EQUAL) conditions and indexes"
Reply: Taylor, Chris David: "RE: Strategies for dealing with (NOT EQUAL) conditions and indexes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message