Hi!
If table is indexed by Recid field, and SET OPTIMIZE option is ON, YES - this SCAN will be optimized.
>Hello everyone.
>
>How does SCAN FOR myTable.Recid = myVariable work?
>Does VFP know to "SEEK" only those record(s) that satisfy the FOR clause or does it scan the whole table?
>
>
>Thanks
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.