首页 > 数据库技术 > 详细

Sql_Handle and Plan_Handle Explained

时间:2017-04-12 20:35:14      阅读:242      评论:0      收藏:0      [点我收藏+]

For batches, the SQL handles are hash values based on the SQL text. For database objects such as stored procedures, triggers or functions, the SQL handles are derived from the database ID, object ID, and object number. plan_handle is a hash value derived from the compiled plan of the entire batch.



http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/09/2-0-sql-handle-and-plan-handle-explained.aspx

Sql_Handle and Plan_Handle Explained

原文:http://www.cnblogs.com/brucemengbm/p/6701106.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!