>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