Difference between OPENQUERY and four part name queries on a linked server

Hi,
I want to understand the difference from point of performance between a query executed through linked server using the OPENQUERY function and using four part name.
My query is structure as follows:
insert into tablename
select * from openquery( linked_server, 'A very complex select statement with lot of outer join and subqueries.' )
Basically, I want to understand how the query is executed and it will consume resources of which server.
Regards,
Chetan

I think that with OPENQUERY you have a better chance of the other server doing all of the work on that part of the query. With a four-part name, your current instance may attempt to retrieve loads of data and do more of the processing locally, which may slow down the query.

Yes, openquery is much faster.....only one problem....is the query string is limited to 8k only. Hence, I had to use DTS.
Regards,
Chetan

[quote user="chetanjain04"]Yes, openquery is much faster.....only one problem....is the query string is limited to 8k only. Hence, I had to use DTS.[/quote]If you can create a stored procedure on the remote server that returns the data you need, then you are much less likely to ever hit the 8K limit.
Of course for a one-time transfer of data, DTS will do fine.