SQLSACT (9/12/2012)
So when the same query executes again, the results can be found in memory, right?
Results, no. The data pages that the previous execution used, yes (providing they haven't been aged out of cache)
So is it safe to say that when the same query executes again, it's not actually doing another Clustered Index Seek
because the results are already in memory?
No, it would be completely incorrect to say that. When the query executes again it does a clustered index seek to find the data. The pages may be in memory rather than disk, but it's still a clustered index seek to find the matching rows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability