© Tracy Boggiano and Grant Fritchey 2019Tracy Boggiano and Grant FritcheyQuery Store for SQL Server 2019https://doi.org/10.1007/978-1-4842-5004-4_7
7. Forcing Plans
Tracy Boggiano1 and Grant Fritchey2
Cary, NC, USA
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 ...