What is the purpose of parent_plan_handle in sys.dm_exec_cached_plans?
-1
votes
1
answer
65
views
I am attempting to prove whether the plan cache is caching statements individually within multiple stored procedures with identical statements. I thought I would be able to use
parent_plan_handle
to see this relationship however it is always returning null.
I've checked this on both SQL 2019 and 2022.
When I consult the literature , the column is strangely absent.
The question: What is the purpose of parent_plan_handle
in sys.dm_exec_cached_plans
?
Asked by WiseTechGlobal CTO
(198 rep)
Jul 13, 2024, 08:06 AM
Last activity: Jul 13, 2024, 05:51 PM
Last activity: Jul 13, 2024, 05:51 PM