>I heard that Foxpro is dowloading all table content when processing SQL queries. Is it true? If yes, how it is possible to reduce the size of the data set being returnet?

No, that's not true unless nothing in the query can be optimized. Use SYS(3054) to figure out how VFP is optimizing the query.

Tamar