I know that. But why would I want to do that ?

>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()'