Magnus,

>I have a question regarding Index on DELETED() and a primary tag with !DELETED() as a filter expresion.

>Let's assume that I have a customer table with cust_id as PK.
I remove a customer and add another customer with the same cust_id (cust_id is not a generated PK). This will generate a duplicate error message. So to solve this problem I add a filter expression on the cust_id PK: !DELETED(). Should I have an Index tag on DELETED() to optimize perfomance?

No, this would not solve the problem that rushmore could not use the tag to optimize performance. Rushmore cannot use filtered index tags.

To enhance performance you could add another regular index with the same expression but without the !DELETED() filter.

Walter,