>I'd say that we get excellent mileage out of VFP's primitive "optimization" stratgey, especially given the simplicity of it all.
I agree. Most of the time, I am quite content with the results.
>The other strategies require significant maintenance and can also get in the way in special cases. Indeed, if VFP had other optimization capabilites (other than index-based) I'd guess that it wouldn't have the wide usage it has today.
One big advantage with VFP is that it is relatively cheap (as compared to Oracle, for instance! - which I used for the comparison).
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)