Hi Naomi,
>>huh? locate for command is fast if there are all aprropriate indices that match left part of index expression.
>>and i think that locate for field1=key1 and field2=key2 will be blazingly fast when there are indices for field1 and field2 and index on deleted().
>
>With index on DELETED() you're going into the battle field <g>
am i missing something???
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer