Caching Linked Server Queries

Hi,
Is the result of query via Linked Server cached? Or it depends on the data
source type of Linked Server? What about the exeution plan?
Thanks,
Leila
Leila (Leilas@.hotpop.com) writes:
> Is the result of query via Linked Server cached? Or it depends on the data
> source type of Linked Server? What about the exeution plan?
The result is not cached. The exucution plan is cached, just like for
any other query.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx