Hilmer-

>Perhaps there was a small misunderstanding here.

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.



>Creating the additional index is only worthwhile if you frequently access data on one specific set of criteria.

Again, a lucid discussion of the issues. Thank you.