I did set it as BINARY index. I changed all my logical field indexes to binary a long time ago. My reasoning for what I said is that I would have to go back to anywhere where I didn't have the READWRITE or NOFILTER clause and expected to show the RECCOUNT() like the example I posted, then it would be wrong. Recall my example wasn't about locating a particular record but knowing how many it was if not a single match.
On 6/25/2020 5:07 AM, Jürgen Wondzinski wrote:
The INDEX on DELETED is absolutely ok, if you do it as a BINARY index. The BINARY index is basically the rushmore map. Each record is represented as one bit, thus the resulting indexmap is way smaller and faster than the traditional indexing map.
[excessive quoting removed by server]