>>Be careful. It is my experience that an index on deleted() can make local queries (not over a network), and with few records, faster; but the same query over a network, and with many more records, might actually get slower. Before deciding to keep the index on deleted(), you should test under real-life circumstances, for instance, over a network and with the number of records you expect to have in the near future. > >Really? I haven't encountered this -- under what circumstances is this the case?
He refers to a situation first reported by Chris Probst in his article "Rushmore - Less Is More" in FoxPro Advisor - May 1999.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry