>>>Now I am not sure :). And even if I remembered where I read it (release notes, help or what), I can't remember which version was that and whether it's still so. Therefore you may actually be right, that I either misremember (from "indexes are used for ordering records", "indexes are used when selecting records" I may have cut short to "indexed are used when ordering selected records"), or what I remember held for VFP 4.
>>
>>I guess we need Fabio or Sergey to clarify :)
>
>VFP doesn't use index to optimize GROUP BY or ORDER BY.
>
>VFP9 skip the ORDER BY ASC when it match the GROUP BY clause fully.
Thanks for clearing this up.
If it's not broken, fix it until it is.
My Blog