>>AFAIK, VFP doesn't use indexes to optimize GROUP BY so answer still the same, WS.
>>
>In other words, if I want to speed up the lenghty process I need to select all records to cursor first, then do group by on a resulting cursor, correct?
>
>I'm going back and forth and can not achieve a good performance...

I'm not sure I follow you. If you have a WHERE and GROUP BY, VFP must filter the records before it can group them. It does that in the one SQL command. I doubt doing the grouping in a second SQL command would be faster.