Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only