Hi Javed,

Add a FOR !DELETED() clause to the index filter expression
For rushmore optimization, you could add an extra normal expression:

INDEX ON MyPrimary KEY Tag Mypk2


Walter,
>Hello every body,
>
>I have problem with primary key, when I delete record and enter new record with same value in primary field error come value already exist. If any body has a solution, please reply