>- Are you accessing data on a local or a network drive?

Local

>- Do you have antivirus active?

This is on a server and there is no antivirus running.

>- What is SET DELETED, and do you have a tag on DELETED()?

SET DELETED ON

There are no tag on DELETED(). I see that as soon as I put the tag on it, it went fast. This table comes from a remote location. So, I will have to ask them to add a tag there. But, usually, I don't have a need anymore to use this tag. I have found that since a few versions of VFP, that this doesn't change anything as far as optimization goes.

>- Are any #DEFINEs active?

No

>- Do you get the same result from a plain Command window?

This is from command window.

>- Do you get the same result on second and subsequent tests?

Yes