>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