News
Using the RECOMPILE hint is not for all queries, and you should be careful with it; it just provides an easy-to-use example of how Query Store hints can be implemented.
In SQL Server 2017, automatic plan correction was added, which allows for the database engine to automatically use the "last known good plan" for a query that has suddenly regressed in performance.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results