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.