Hi Dragan,
>I just want to know does VFP's SQL read the deletion mark of all the records, or only the retrieved records. That would make a difference. BTW, how come nobody mentioned this tag in 2.x? Not that I can remeber.
Without an index on DELETED(), VFP searches for deleted records after it applied Rushmore. IOW, only those records that match a criteria are loaded from disk and verified. And VFP does than in any case to filter out changes from other machines that were done in the meantime. Only count operations completely work on the index and are really speeded up by an index on DELETED().
Christof
--
Christof