CODEWITHSUNDEEP
sql-server-2008caching
JsCoder
JsCoder

Reputation: 1733

Can MS SQL Server 2008/2012 cache SELECT query results

Can MS SQL Server cache select query results just by itself and if so how do I enable it?

Upvotes: 0

Views: 5548

Answers (2)

George
George

Reputation: 1054

Depending on what you're trying to do a way to do this might be to create indexed views

See:

http://msdn.microsoft.com/en-us/library/dd171921%28SQL.100%29.aspx

Upvotes: 1

Martin Smith
Martin Smith

Reputation: 453067

No it doesn't cache actual results (like the MySQL query cache).

however the data pages that are read during a SELECT are first brought into the buffer cache. Subsequent requests reading the same data can thus be served quicker than the initial request without needing a trip to disc.

Upvotes: 2

Related Questions