>>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.
Thanks,
Patrick
Senior Analyst/Programmer
Lexington, KY
(Basketball, Bourbon & Horses... What Else Matters?)