>John,
>
>My vote is to follow Hilmar's advice. However, for Rushmore purposes you may need to have another index on that same field, without the filter on not deleted(). This index would be a regular index (as opposed to candidate).
That's right - depending, of course, whether it is a PK or a CK. For a PK it would be almost obligatory, for a CK, it may or may not be needed.
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)