If I have a large file with, say 100 fields in it and 1000 records. If I need only 10 of the fields to be updated, will my app perform better if my SQL gets only those 10 fields, instead of all fields? Also, if I have to orphan a field in a free table because it's name is a reserved word in VFP, what kind of memory issues occur if I continue to retrieve this field (25 characters) in a SQL select *; blah,blah,blah?

TIA
Mike