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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement