Bret, Josh,

>>Yes I have set deleted on and I have an index created on the key field, which is included in the query.
>
>Do you have an index on DELETED() in the table?

This is dangerous. If the the underlying table does not contain significant amounts of records, the DELETED() tag will only slow down your view. Full optimization is no guarantee that it won't be slower than partial optimization.

There are proven cases where the index on deleted slow down performance significantly.


Walter,