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.

One way to use this functionality is by locating a value related by column with comparable data in two tables. For example, I have a database with two tables, Album and Lyric.

VALUES as valid SQL. You must specify at least one column, but you may use the DEFAULT keyword to allow the default value rather than hard-coding a value, so the following is valid syntax that ...