If you're doing a simple select statement with where conditions, the query will be processed at the remote site and just the rows that satisfy the where clause will be returned. However, if you are joining a local and remote table, the query will be performed locally.
