>I have nothing more to go on that you do *except* that I have had experience that VFP still goes to the actual table EVEN IF the fields in question are ALL indexes.


Jim, have you noticed any difference between these 2 constructs? Assume that fields X and Y are both independently indexed as 2 separate tags:

Select X,Y from Tbl where X=1 and Y=2 && Full Optimization?

Select X,Y from Tbl where X=1 && Partial Optimization, even though both X and Y are indexed, because Y is not used here as part of the search criteria?