>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.
>
>
>Thanks, steve
You should usually
not do this, since this index will give you full Rushmore Optimization. Partial R.O. is often better. See FAQ #8109.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)