如何在SQL Server 2005中使用查询缓存?

问题描述:


我想对使用ASP.Net开发的网站使用查询缓存,并且我的数据库是sql server.
我不知道该怎么办.
sql server会自动执行吗?
我该如何使用?


I want to use query caching for my web site that developed with ASP.Net and my database is sql server.
I don''t know how can I do it.
does sql server do it automatically?
how can I use it?
and the end is it true to use it?

已阅读本文档,它解释了SQL Server 2005中可用的不同类型的查询缓存.

SQL Server查询缓存 [
Have a read of this document it explains the different types of query caching available in SQL server 2005

SQL Server Query Caching[^]