© Tracy Boggiano and Grant Fritchey 2019
Tracy Boggiano and Grant FritcheyQuery Store for SQL Server 2019https://doi.org/10.1007/978-1-4842-5004-4_7

7. Forcing Plans

Tracy Boggiano and Grant Fritchey2
(1)
Cary, NC, USA
(2)
Grafton, MA, USA
 
While the information collected in the Query Store and all that it tells you about the performance of your system is the part of Query Store that you’ll use more frequently, the most powerful part of Query Store is the ability to force execution plans. Plan forcing is where the choices made by the optimizer during a compile or recompile event are superceded by a plan you select. Query Store provides enough information between the performance metrics and the execution plan to enable you to decide that, under some ...

Get Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.