>Hilmar, I don't think you missed something, but I didn't take the time to be 100 % clear;
>
>I tried to say this :
>
>The view will get all the records you select
Agreed.
>The other thing I said, is that with (native tables) creating the view, this is done within the PC, and in order to do that, ALL the records of the table will get downloaded to the PC. So maybe here is where you disagree.
Yes, I do disagree. The way Rushmore Optimization seems to work is that first, all index keys are obtained. If few records match the criteria, this can be very fast, because the index is NOT stored sequentially - it is a tree-like structure.
However, depending on the conditions, VFP may have to get LOTS of index keys from the index - perhaps most of them. See my FAQ on Rushmore Optimization, for details.
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)
