General information
Category:
Coding, syntax & commands
Hilmar-
>Remember, too, *not* to include any index on the expression deleted(); this will also return too many records.
I really enjoyed your very lucid discussion of optimization. Just a small quibble. If people have a filter on DELETED() on the PK index, then they should have an index on Deleted(). Which can cause the problems you point out.
All the more reason to use surrogate keys...one doesn't need the deleted() filter.
Previous
Next
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