Re: Function based index with <>

  • From: Adric Norris <spikey.mcmarbles@xxxxxxxxx>
  • To: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
  • Date: Wed, 19 Aug 2009 21:59:34 -0500

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: