sql_handle vs. plan_handle

sql_handle: is the hash of the original T-SQL source.

plan_handle: is the hash of the cached execution plan.

The important thing to note is that you can have many sql_handles to 1 plan_handle due to parameterization[1. Wrox’s “Professional SQL Server 2012 Internals and Troubleshooting pg 115].

Views – 2560

Leave a Reply