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?

Cheers,

Jim N

>
>Also, I've found that on large tables any SEEK is waaaaayyy faster than even a fully optimized LOCATE. For whatever reason, Rushmore is not very efficient with LOCATE...