Hi and thanks for your answer!

About the query it has not join, only simple select.

the query is something like this:

select * from openquery([LinkedServerName],'select X,y,z from AB')

"transferring large amounts of data":...