>If SET DELETED is ON, you need an index on Deleted() on both table for a full optimization.

Yeah, and will probately slower than partial optimization. The deleted(0 tag should not be used. Especially on table with no or just a few deleted records.

Just see the discussions held the past few months regarding the deleted() tag.

Walter,