>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,
I guess I have not hit any of those cases yet. All my apps seem to perform well with the DELETED index tag. My tables range from a few records to 5 million.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope