>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only