>>>I just completed running a test using the Deleted()
>>>Index tag. I created 2 Identical Tables of about
>>>1.7 Million records, one with the deleted() Tag and
>>>one without.
>>>
>>>I ran a series of identical queries and below are the results:
>>>
>>> With Deleted() Tag Avg of 24.4152 Seconds
>>>Without Deleted() Tag Avg of 16.5155 Seconds
>>
>>When you say "with Deleted() tag", does that mean you SET INDEX TO deleted, or that you have an index on deleted()?
>>
>>The same for "without": you didn't set the order to that index or such an index doesn't exist?
>>
>>Vlad
>
>
>I mean there is an index for the 'with' and not an index for 'without'.
>
>These tables currently have no deleted records, I guess that makes the
>difference. I will randomly delete some records and test again.

Also:
Don't set any current order and quit&reopen VFP between any 2 tests.

Vlad