Hi Walter,
>I said: To my best knowledge VFP doesn't use full index scan (or coverage ?) to optimize queries. But to prove this, you must test al possible cases. IOW 100% prove is hard to get.
Well, you can verify this and I just did. The way to proof this is to create a table with an index. Than delete the table, rename the index and create a new table with the same structure but different values. Finally copy the index of the first table over the second index. When you search, you should either get the results from the table or from the index.
The result is, you are right... and I'm right. *s* VFP does a full index scan first. But then it verifies that every record in that result set really matches the condition. One exception here, as I've mentioned before, is COUNT. This command only uses the index.
Christof
--
Christof