http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/09/2-0-sql-handle-and-plan-handle-explained.aspx2.1 What is a Plan_Handle Cached compiled plans are stored in the SQLCP or the OBJCP cache stores. A cached compiled plan can be retrieved from either of these cache stores using the plan_handle of the compiled plan. The plan_handle is a hash valueen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/09/2-0-sql-handle-and-plan-handle-explained.aspx#1456882Fri, 12 Jan 2007 21:44:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:1456882SQL Programmability & API Development Team Blog<p>P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-style-parent:</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=1456882" width="1" height="1">