How are joins performed when using a database link?

We are doing lots of data loads using database links and I need some advice.

I have a part table and want to load all parts I do not have. Should I bring the entire table over to a temp table and then get the records that I want?
Or should I join across the database link and pull back just the records I want?

I'm not sure where the join is performed. If the entire table must come over and then join in memory on my local box it would probably be better to pull all the data first, then join in another query. But if it can somehow restrict the rows and send me just what I want it would be better to join accross the link and send less data.

Any advice?

Don Received on Sun Mar 16 2003 - 19:48:55 CST