>>No, there wasn't a misunderstanding. I merely qualified your flat statement that one shouldn't have an index on deleted() and gave the exception. That's all. Althought I did leave out the additional qualifer that it depends also on whether one uses SET DELETED ON or OFF.
>
>Oh, sorry. My misunderstanding, then.

Oh, really not a problem at all. It was a very minor point, and I didn't mean to distract from your excellent post.