>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?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope