Or delete the record a second time.
>Note that this will cause a problem if you try to recall a deleted record.
>
>>Add
for !deleted() to your primary/candidate key clause
>>
>>This index will not be used for Rushmore optimization. But you can get around that by adding another regular index with the same expression without the 'for !deleted()'