Does SQL Server CACHES Query Results? [duplicate]
SQL Server does not cache the query results, but it caches the data pages it reads in memory. The data from these pages is then used to produce the query result. You can easily see if the data was read from memory or from disk by setting SET STATISTICS IO ON Which returns the following … Read more