>The GO BOTTOM has to be there to validly compare the processes. It's the differences that important.
David,
Why do you think it is needed? SEEK and INDEXSEEK always work on the index. It starts at index node 1 and works its way from there. There is no performance boost if the record pointer starts on the same. VFP does not check the current record before accessing the index. VFP still has to search the index.
>Think about it, if INDEXSEEK has to respect filter conditions, and the set deleted on, then the dataset has to be accessed and paged into memory to determine this. The filter info, including the delete mark, is not in the index.
>
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao