>>I understand that VFP uses available indices automatically (whether this speeds things up or not - sometimes it doesn't) for all aspects of query optimization.
>>
>
>No, Rushmore looks at available indexes to see whether any of them will speed up the operation. If you look at SYS(3054) output, sometimes you'll see that VFP uses a temp index even when there's one available.
>
>Tamar
Now, this is interesting. I was assuming that any index would be used, as long as it appeared in the expression.
Do you happen to know - or have a guess - what criteria VFP would use to use or reject an index?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)