>>But Dan suggested, and I thought it was a good idea, to add to VFP the capability to be able to explicitly tell VFP to NOOPTIMIZE any specific clause.
>>
>>Your second statement seems also to agree with the benefit of this. Correct?
>>
>>Cheers
>>JimN
>
>I agree completely on the potential benefit. It would be easier to disable a specific index in a SELECT - SQL statement than it is to delete an index!
>
>Workarounds are sometimes possible, though. Like the one I mentioned in a specific example: "DocumentDate + 0 > ldDate" will only be "Optimized", in my understanding, if you happen to have an index on "DocumentDate + 0".
>
>Hilmar.

And I agree that workarounds are possible. But you know the problems with workarounds < s >.

Cheers
JimN