Re: Function based index with <>

On Wed, Aug 19, 2009 at 21:42, Tony Adolph <tony.adolph.dba@xxxxxxxxx>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.

Other related posts: