General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only