Azure SQL Database Automatic Plan Correction: A Safety Net for Plan Regressions
Azure SQL Database can detect plan regressions via Query Store and automatically force the last good plan. Here's how FORCE_LAST_GOOD_PLAN works, how to inspect it, and where it falls short.
azuresqldatabase