Information générale
Catégorie:
Codage, syntaxe et commandes
Glenn,
You say
"...you probably can maintain an index on Deleted()because there are so few so as not to create a problem.".
But that is precisely the problem - with only a small percentage of entries that *are* Deleted(), then given a reasonably large number of records performance will be adversely affected every time when running with DELETED set ON.
It is NOW known that an index on DELETED() is a bad thing *most* of the time.
Cheers,
JimN
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