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
   

   WingSzeto, Jan 22, 2009

   #2
2. satya Moderator

   Review this article: http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx that explains the complete information which is applicable to 2008 too.
   

   satya, Jan 23, 2009

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in