markus,

>> In my testing table of 1.900.000 records i've deleted about 19.000 records
>> and could not find any significant difference with or without the deleted() tag.

>In this case the problem seems to be that the entire statement isn't optimized. Have you tried Sys(3054,1) to see the optimization level?

It was never the goal to reach full optimization. I did just check the influence of the deleted tag in a rushmore optimizable (partual) expression, and it was about none.

This just means that even if you reach full optimization it would run just as fast as the same query but without the index on DELETED()

But for the record, i'll check this.

Walter,