Re: Function based index with <>

From: Adric Norris <spikey.mcmarbles_at_gmail.com>
Date: Wed, 19 Aug 2009 21:59:34 -0500
Message-ID: <d4beff360908191959u5ec0ec78lfd4cb973d3b4d0c9_at_mail.gmail.com>

On Wed, Aug 19, 2009 at 21:42, Tony Adolph <tony.adolph.dba_at_gmail.com>wrote:

> You need to use the *same expression* in your query, e.g
>

Yes, I'm aware of that. The scenario described by the original poster, however, doesn't allow for the query to be modified... to recap:

I have an *app generating SQL which I can't change*. The following sql causes FTS on a big table
 AND DELETE_FLG <> 'Y'

That's the situation I'm currently examining.

-- 
"I'm too sexy for my code." - Awk Sed Fred.

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

Received on Wed Aug 19 2009 - 21:59:34 CDT