>SNIP
>
>Hi Bruce,
>
>Basically I use SEEK (either one) whenever I can, but something came up last month and I'd like to get to the bottom of it. Your observations with LOCATE may help in that quest. . .
>
>The manual says that any command (including LOACTE) will *not* be Rushmore optimized when a WHEN is included in the FOR condition(s). JimB says that WHEN has no effect on Rushmore.
>So the question is: Did your observations of LOCATE include a WHEN condition?
Hi Jim - no, I'm speaking of only the simplest case,
LOCATE FOR mytable.myfield = cSomeValiue
with a valid index on myfield...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.