Query Cache?

Does SQL Server have a query cache similar to mysql, whereas the query
result is cached, if the table has not been changed?

If so, please refer me to more info.

Thanks.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/General-Dis...pict170423.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=571428steve (UseLinkToEmail@.dbForumz.com) writes:
> Does SQL Server have a query cache similar to mysql, whereas the query
> result is cached, if the table has not been changed?

SQL Server maintains a cache, but certainly not with canned results for a
queries. In a OLTP system, many tables are frequently updated, so such the
likelyhood the of the same query yielding the same result twice is not that
fantastic. And for that matter, the likelyhood of the same query reappering
with the exactly the same parameters is not that extreme either. It is also
worth to keep in mind that most queries refers to more than one table.

What SQL Server has in its cache are recently accessed data pages, as well
as query plan for recently submitted queries and invoked stored procedure.
This makes it possible to retrieve the result of a query without accessing
the disk for frequently accessed tables. Note here that this cache works
better, the bigger it is. Thus, spending cache on less usful information,
such as canned query results, may have adverse results on performance.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp