Hint

Swipe to navigate through the chapters of this book

2016 | OriginalPaper | Chapter

26. Plan Caching

Author: Dmitri Korotkevitch

Publisher: Apress

Published in: Pro SQL Server Internals

» Get access to the full version

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.

Please log in to get access to this content

To get access to this content you need the following product:

Computer Science Explorer

Purchase now

Title

Plan Caching

Book

Pro SQL Server Internals

Print ISBN: 978-1-4842-1963-8

Electronic ISBN: 978-1-4842-1964-5

https://doi.org/10.1007/978-1-4842-1964-5

DOI

https://doi.org/10.1007/978-1-4842-1964-5_26

Author:

Dmitri Korotkevitch

Publisher

Apress

Sequence number

Chapter number

Chapter 26