2016 | OriginalPaper | Chapter
26. Plan Caching
Published in:
Pro SQL Server Internals
Abstract
Query optimization is a resource-intensive process that could introduce a significant CPU load on busy servers. SQL Server tries to minimize such load by caching plans in a special part of the process memory called the plan cache.