>>>>>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 :)
If it's not broken, fix it until it is.
My Blog