>>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???
>
>See
http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndexyeah, that's right. but it does apply only for networked apps where the tables are accessed from the server.
the case here doesn't mention network ;)
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer