Hi John,

>Why then does sys(3054) return partially optimized when I have Set Filter On and I don't have a deleted tag....???? If I then set deleted off, my query is then fully optimized...
>
>Is VFP lying?????

Of course not. But "fully optimizable" doesn't correlate to "faster" or "being a good thing".

Christof