>>>>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.