Query Store hints are now available within SQLServer 2022, Azure SQL Database and Azure SQL Managed Instance.
When it is required to manually optimise queries for specific conditions rather than use the Query Optimizer execution plan, this new Query Store hints capability delivers a simple method for shaping query plans and behaviour. All without changing the applications’ code.
Try it out in SQL Server Management Studio or Azure Data Studio.
You can find out more here.
