>Always interested in database performance techniques. I remember reading somewhere about creating an index on deleted records to speed up access. I have a particular table that the number of deleted records grow quickly. I was wondering if anyone can tell me how to set up that index properly.
>
>

Steve,
There have been several discussions over the last year or so that states this isn't necessarily a good thing. See Message#528010 for an example.

However, if you situation is unique in that this tag may help:

index on deleted() tag deltag

is the syntax to set it up.

HTH. Good luck!