Hi John,
>If you have a decent amount of deleted records, and you have set filter on, and the table is of an appreciable size, performance can improve with a deleted tag.
I could argue about this, but I think everything has already been said.
>Actually, the original question was whether Set Deleted was an internal filter on deleted records...
...and whether it is better to SET DELETED OFF because of speed issues...
>Truth be told, I was hoping to bait somebody into the whole deleted tag argument without actually addressing the argument...< bg > Looks like it worked...
Well, I as an MVP have to watch out what other MVPs say, because... you know. *bg*
Christof
--
Christof