本文解释了SQL处理和数据库对象处理的区别，重点介绍了计划处理（plan_handle）是如何从整个批处理的编译计划中导出的。通过链接提供深入的技术解析。
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
扫一扫
788
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
