是否可以在sql server 2008中缓存结果集？ [英] Is it possible to cache result set in sql server 2008?

问题描述

是否可以在sql server 2008中缓存结果集？



谢谢。

Hi,

Is it possible to cache result set in sql server 2008?

Thanks.

推荐答案

我认为这是不可能的。

即使SQL Server本身缓存查询计划，存储过程等，无法从程序AFAIK访问此缓存。



如果您想暂时存储结果，对它们进行一些处理，您可以随时使用临时表然后放下桌子。

快速概述：SQL Server 2005中的临时表 [ ^ ]可能会帮助您开始使用临时表。

I don''t think this is possible.
Even though SQL Server itself caches query plans, stored procedures etc., there is no way to access this cache from a program AFAIK.

You can always use a temporary table if you want to store results temporarily, do some processing on them and then drop the table.
Quick Overview: Temporary Tables in SQL Server 2005[^] might help you get started with temporary tables.

http://msdn.microsoft.com/en- us / library / aa342326（v = sql.105）.aspx [ ^ ]



http://www.mssqltips.com/sqlservertip/1661/analyzing-the-sql-server-plan-cache/ [< a href =http://www.mssqltips.com/sqlservertip/1661/analyzing-the-sql-server-plan-cache/target =_ blanktitle =New Window> ^ ] < a href =http://blog.sqlauthority.com/2007/03/23/sql-server-stored-procedure-clean-cache-and-clean-buffer/> http://blog.sqlauthority.com/ 2007/03/23 / sql-server-stored-procedure-clean-cache-and-clean-buffer / [ ^ ]

http://msdn.microsoft.com/en-us/library/aa342326(v=sql.105).aspx[^]

http://www.mssqltips.com/sqlservertip/1661/analyzing-the-sql-server-plan-cache/[^]http://blog.sqlauthority.com/2007/03/23/sql-server-stored-procedure-clean-cache-and-clean-buffer/[^]

这篇关于是否可以在sql server 2008中缓存结果集？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！