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?????

>Hi John,
>
>>If you don't have a deleted tag, and you have set filter on, your queries are never totally optimized. Other things take a hit as well. This is why it is a good practice to have a deleted tag...
>
>Which is actually wrong. Whether or not you need an index on deleted depends mainly on whether you count records in that table or not (the issue of filtered result sets aside). That's a fact.
>
>Christof