SQL Server Performance

Does index cache in memory after queries done with their execution

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by WingSzeto, Jan 22, 2009.

  1. WingSzeto Member

    When a query is executed by utilizing an index, does SQL retrieve the entire index to the memory and do the search or it just perform the IO direclty with the disk(s) which contains the index and no caching? I like to know more details about how it works If it does some caching, is it in procedure cache? If so, will SQL age them accordingly?
    wingman
  2. satya Moderator

Share This Page