http://blogs.msdn.com/b/sqlprogrammability/archive/2006/05/04/ketan-duvedi.aspxProcedure cache which is also called as plan cache is primarily a cache of the query plans to improve performance of query execution. By caching the compiled and execution plans we don’t have compile query each time they are executed. This is a huge performanceen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlprogrammability/archive/2006/05/04/ketan-duvedi.aspx#6184250Wed, 14 Nov 2007 00:38:37 GMT91d46819-8472-40ad-a661-2c78acb4018c:6184250QuintaStation<p>Esta ma&#241;ana Iv&#225;n me preguntaba sobre una afirmaci&#243;n que pon&#237;a en las conclusiones de art&#237;culo &amp;quot;Visualizaci&#243;n</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=6184250" width="1" height="1">http://blogs.msdn.com/b/sqlprogrammability/archive/2006/05/04/ketan-duvedi.aspx#1440640Wed, 10 Jan 2007 01:22:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:1440640SQL Programmability & API Development Team Blog<p>The plan cache is comprised of 4 separate cache stores: Object Plans (CACHESTORE_OBJCP), SQL Plans (CACHESTORE_SQLCP),</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=1440640" width="1" height="1">http://blogs.msdn.com/b/sqlprogrammability/archive/2006/05/04/ketan-duvedi.aspx#1437229Tue, 09 Jan 2007 04:54:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:1437229SQL Programmability & API Development Team Blog<p>The plan cache is comprised of 4 separate cache stores: Object Plans (CACHESTORE_OBJCP), SQL Plans (CACHESTORE_SQLCP),</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=1437229" width="1" height="1">http://blogs.msdn.com/b/sqlprogrammability/archive/2006/05/04/ketan-duvedi.aspx#757206Sat, 16 Sep 2006 09:41:54 GMT91d46819-8472-40ad-a661-2c78acb4018c:757206Cristian's BlogIf you want the complete answer you should take a look at the following post What are the different cached...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=757206" width="1" height="1">