Hi Walter,
>When using an index on deleted on a large table all the indexrecords regarding to non-deleted records should be in memory. Because of that in this type of index you can only have .T. or .F. this would be the majority of all the indexrecords of the deleted tag(). This could theoreticly lead to the disability of rushmore to optimize.
That's right. A bitmap of the entire index is kept in memory (occupying RECCOUNT()/8 bytes memory). But only all index blocks of _deleted_ records are read into memory. That's usually the minority of records. Thus, memory usage is high, network traffic is low, but higher than without index.
Christof
--
Christof