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