Hi

I have a table that contains 192,216 records, 177,493 of these are deleted records.

I have a DELETED() Index on the table, yet when I run a command like SCAN FOR...ENDSCAN on an indexed field, it takes absolutely ages. This is over a 1MB WAN by the way, but it still should only take seconds, it takes minutes, about 3 to be exact.

What am I doing wrong here?

Thanks
Kev