>>>>>>May I ask WHY you need such an index tag? If you have index tags on the relevant fields, a SQL Select statement is normally instant, and most likely gives you exactly what you really want.
>>>>>
>>>>>I think INDEXES have no bearance on the ORDER BY clause.
>>>>
>>>>Except on speed - if your SQL uses Order By something you have a tag on, Fox uses that to speed up the ordering - or else it would have to build a temporary index or use some other means of ordering the records. So having a tag helps.
>>>
>>>Hi Dragan,
>>>
>>>Before your reply I was 100% sure that indexes are not used in GROUP BY and ORDER BY by Rushmore. Now I'm only 99.99999% sure. Could you please verify?
>>
>>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.