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